if a certain value is above...colour it?

K

koldtooth

ok i am doing a spreadsheet of working hours, and i have the following
formula in the cells:

='Daily Hours'!CG24

is there anyway to add a formula in there so that when it reaches a
value of, lets say 50 hours, it changes the text colour to red?

or is there a lookup formula that checks to see any values above 50 and
then colour them red?

any help would be great!!

thanks!
 
B

Bondi

Hi ,

One way would be to use Conditional Formating under the Format menu.

Regards,
Bondi
 
P

Paul Mathews

You'll want to use conditional formatting. Click on the cell you want to
have the formatting (CG24), the click Format>Conditional Formatting... Set
the condition to "Cell Value Is", "Greater than or equal to", 50. Then click
the format button and, in the "Font" tab select the colour red from the
palette.
 
Top