Search code examples
google-sheetsconditional-formatting

Google Sheets - Conditional Formatting - One Cell Based on Another Cell Text

I would like to conditional format the "N - I - P" cells based on the cell data in Column A. Each row might have a different value in Column A. Is there a quicker way to conditional format?

Link to Spreadsheet with Example.

enter image description here

Solution

  • Use Custom Formula.

    Rule:

    setup

    Formula:

    =IF(AND(A1=E1,NOT(ISBLANK(E1))),1,0)

    or

    =AND(A1=E1,NOT(ISBLANK(E1)))

    Just change E to D and C for other columns. Do not forget to also update the Apply to range per color.

    Output:

    output