Having a value automatically change color
You are welcome, thanks for the feedback.
--
Cheers,
Shane Devenshire
"John" wrote:
Thanks Shane, Really appreciate the help..
John
"Shane Devenshire" wrote:
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
"John" wrote:
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?
|