Formatting in a Formula

F

Frank

Does anyone know a way I can add a fill color to a cell if the value exceeds
a threshold (ie an alert)?

Thanks,
 
J

JulieD

Hi

Yes, use conditional formatting

click in the cell in question
choose format / conditional formatting
choose
cell value is
choose greater than (or whatever)
enter the value
click on the format button
set the formatting
click Ok, and Ok again

Cheers
JulieD
 
Top