Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fill Color on error
I have this worksheet I use that someone prior to me created. It is set up
to highlight a cell in red when I put in a negative in that cell - telling me I can't do that. Does anyone know how this is done? I looked at Data/Validation, but that is blank There are no Macros and there are no formulas that I can see. Any help would be appreciated. Thanks, Stephanie |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fill Color on error
It's probably done with conditional formatting.
Select a cell that produces this behavior. Goto the menu FormatConditional Formatting Do you see any settings? Biff "steph44haf" wrote in message ... I have this worksheet I use that someone prior to me created. It is set up to highlight a cell in red when I put in a negative in that cell - telling me I can't do that. Does anyone know how this is done? I looked at Data/Validation, but that is blank There are no Macros and there are no formulas that I can see. Any help would be appreciated. Thanks, Stephanie |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fill Color on error
Sounds like conditional formatting.
Format--Conditional formatting. Dave -- Brevity is the soul of wit. "steph44haf" wrote: I have this worksheet I use that someone prior to me created. It is set up to highlight a cell in red when I put in a negative in that cell - telling me I can't do that. Does anyone know how this is done? I looked at Data/Validation, but that is blank There are no Macros and there are no formulas that I can see. Any help would be appreciated. Thanks, Stephanie |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fill Color on error
Yes, thank you.
"Biff" wrote: It's probably done with conditional formatting. Select a cell that produces this behavior. Goto the menu FormatConditional Formatting Do you see any settings? Biff "steph44haf" wrote in message ... I have this worksheet I use that someone prior to me created. It is set up to highlight a cell in red when I put in a negative in that cell - telling me I can't do that. Does anyone know how this is done? I looked at Data/Validation, but that is blank There are no Macros and there are no formulas that I can see. Any help would be appreciated. Thanks, Stephanie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
basics? | New Users to Excel | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
How to fill colour in Excel, it appers No fill in my computer? | Excel Discussion (Misc queries) | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
#REF error | Excel Worksheet Functions |