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