Thread: Easy one...
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Easy one...


Use conditional formating on the worksheet. Change setting to Cell Value
Less than and put I5 in the value box.

"John" wrote:

I have a sheet that updates from an external feed...

I want to change cell J5 to "STOP" and format it RED if cell V5 is below the
value found in I5

is there an 'on calculate' command?