cell color if value greater than 3

  • Thread starter Thread starter viveleroi0
  • Start date Start date
V

viveleroi0

Is there a way I can have excel mark a column or text RED if the valu
inside the cell is higher than three
 
Look at Format | Conditional Formatting...

Regards

Trevor
 
Yes. Use conditional formatting for this. It's on the Format menu. Assuming
you want an entire row to be red based on the value in column C, you would
select the cells to be formatted, i.e. the entire row, say 5. Then goto
Format/Conditional formatting, and select the Formula Is from the left-hand
drop-down and type =$C5>3 as the criterion. Then select the format, either
red interior or red font.
 

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

Back
Top