Cell turning red

P

Peter Carlson

I have a spreadsheet that I inherited. Whenever there is a numeric 1 in
a cell the cell turns red. Whenever anything else is in the cell it is
clear. I have scoured the macros and vb script (none exist of either).
I have examined the cell properties and I can't figure out how this is
done. Any ideas?

Peter
 
P

Paul B

Peter, select the cell and go to format, conditional formatting and see if
anything is there
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
J

Jean Ruch

Peter Carlson said:
I have a spreadsheet that I inherited. Whenever there is a numeric 1
in a cell the cell turns red. Whenever anything else is in the cell
it is clear. I have scoured the macros and vb script (none exist of
either). I have examined the cell properties and I can't figure out
how this is done. Any ideas?

Peter
Click to expand...

Hi Peter,

ave you already looked at

a) for a conditional formating
b) any event macro ?

regards

Jean
 
P

Peo Sjoblom

Select the cell, do format>conditional formatting, most likely it is set to
either

cell value equal to 1 or formula is

=A1=1

where A1 would be the cell in question


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com
 
P

Peter Carlson

conditional formatting was it...that was simple...didn't even know it
existed. thanks
Peter
 
P

Paul B

Your welcome, thanks for the feedback
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Top