Conditional Formating Question
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.
Column 1, Row 1 = A, then color the cell red. Any other Column/Row combo where the value = A, color it red.
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.