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?

CodePudding user response：

Use Custom Formula.

Rule:

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: