Conditional cell highlighting

  • Thread starter Thread starter judy
  • Start date Start date
J

judy

If column C has an n in it I would need any row within Column C with the n to
highlight yellow. The columns in the row that would need to highlight yellow
are A through and including CB.
 
Click on A1 and:

Format > Conditional Formatting... > FormulaIs > =$C1="n"
and pick a highlight color.

Then copy A1 and paste/special formats form A1 thru CB1


Do something similar to the rows below.
 
Back
Top