Conditional Formating Question

Amy Evans

Hello,

I have a sheet where from columns 1 through 10, I want to apply the same condition but only want to highlight a cell, not a row.

Example,

Column 1, Row 1 = A, then color the cell red. Any other Column/Row combo where the value = A, color it red.

Logic:

A = Red, B = Green, C= Blue, D=Yellow, E = Brown

What is the best way to do this? I do not want to write the same conditions across all ten columns.

Thanks,

Amy

Bassam Khalil

Hi @Amy Evans 

Hope you are fine, you need to create 5 Conditional Formating rule for each column (A = Red, B = Green, C= Blue, D=Yellow, E = Brown). that's mean 50 Conditional Formating rule in your sheet.