Conditional cell highlighting

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.
 
G

Gary''s Student

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top