Having a value automatically change color

  • Thread starter Thread starter John
  • Start date Start date
J

John

I'm setting up a blood pressure monitoring worksheet, and would like to have
one one of the values turn red if it is over 80. I have no idea how to do
this. Help?? Please?
 
Say the cell is B9. Click on it and pull-down:

Format > Conditional Formatting... > Cell Value > Is Greater than > 80
and pic a distinctive format.
 
Hi,

In 2007:
1. Highlight all the cells on the rows you want formatted
2. Choose Home, Conditional Formatting, Highlight Cell Rules, Greater Than
and enter the 80.
3. Open the with dropdown and choose Custom Format, OK.
4. On the Font tab open Color and choose Red.
5. Click OK twice
 
Thanks a million...

Gary''s Student said:
Say the cell is B9. Click on it and pull-down:

Format > Conditional Formatting... > Cell Value > Is Greater than > 80
and pic a distinctive format.
Click to expand...
 
Thanks Shane, Really appreciate the help..
John

Shane Devenshire said:
Hi,

In 2007:
1. Highlight all the cells on the rows you want formatted
2. Choose Home, Conditional Formatting, Highlight Cell Rules, Greater Than
and enter the 80.
3. Open the with dropdown and choose Custom Format, OK.
4. On the Font tab open Color and choose Red.
5. Click OK twice
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire
Click to expand...
 
Back
Top