View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Having a value automatically change color

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?