Conditional format: change row color based on cell value

  • Thread starter Thread starter Carelle
  • Start date Start date
C

Carelle

Example: If A16 is greater or less than 0.9, row A is highlighted in a
specified color.

Do I need to put a conditional format on A16 and then another one on the row?
 
No, in CF use Formula Is (rather than Cell Value Is):
=A$16<>0.9
 
You must log in or register to reply here.

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

Similar Threads

COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Conditional format lowest value greater than zero and copy formula 2
Conditional Format Range of Cells 3
Excel VBA 1
Changing cell colors 1
Looking for assistance for an unusual conditional formatting probl 2
Conditional Format a range based on 1 cell 1
can conditional formatting varry the area it highlights based on c 3

Back
Top