cell color if value greater than 3

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
 
M

Myrna Larson

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