High light data
 

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

High light data
 

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

High light data
 

Conditional Formatting should do the trick. You can set this such that if
the cell value is greater then or equal to 1.4 use red fill. Excel help for
this subject can show you the details. Make sure the base formatting on the
cell is numeric
--
If this helps, please remember to click yes.


"Jerry R" wrote:

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

High light data
 

conditionl formatting is the simple way to solve your query

"David Biddulph" wrote:

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


.

High light data
 

Works GREAT. Thank you very much

"Paul C" wrote:

Conditional Formatting should do the trick. You can set this such that if
the cell value is greater then or equal to 1.4 use red fill. Excel help for
this subject can show you the details. Make sure the base formatting on the
cell is numeric
--
If this helps, please remember to click yes.


"Jerry R" wrote:

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