View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John John is offline
external usenet poster
 
Posts: 2,069
Default Having a value automatically change color

Thanks a million...

"Gary''s Student" wrote:

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.
--
Gary''s Student - gsnu200830


"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?