| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 !! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 !! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 !! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 !! . |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 !! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to high light cells | Excel Discussion (Misc queries) | |||
| Is it possible to high light a row of cells | New Users to Excel | |||
| high light the selected cell | New Users to Excel | |||
| Conditional Formating for dates beyond 30, 60, 90 to be high light | Excel Worksheet Functions | |||
| high light row your working in | Excel Discussion (Misc queries) | |||
Linear Mode
