What you need to look up in Excel help is "conditional formatting".
--
David Biddulph


"Jerry R" wrote in message
...
I have a spreadsheet that tracks water usage our city. There is a sheet
that
draws from another input sheet. The cell already has a formula in it,
example
( =if(inputa3="","",inputa3). What I want to do is if the data is 1.4 or
greater to be the color red so it stands out. Is this possible? Have tried
several differant things with no success. THANKS !!