Message Alert for Changing cell data

J

jsmith59

I run a daily report in Excel that tracks levels of products in tanks
It is important to be able highlight tanks that do not change levels o
any given day. I insert the date in the report automatically. Iwoul
like to know how to flash an alert when any selected tank level does
not change for that specific da
 
D

Don Guillett

How about conditional formatting to change the interior color
format>conditional format>select formula is>=a2<>b2>format as desired>OK
 
Top