Fill Color on error

S

steph44haf

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
 
B

Biff

It's probably done with conditional formatting.

Select a cell that produces this behavior.
Goto the menu Format>Conditional Formatting

Do you see any settings?

Biff
 
S

steph44haf

Yes, thank you.

Biff said:
It's probably done with conditional formatting.

Select a cell that produces this behavior.
Goto the menu Format>Conditional Formatting

Do you see any settings?

Biff
Click to expand...
 
Top