Cell changes color

J

JG Scott

I have a range that is all colored yellow. For some reason, one of the
cells changes to white when the user enters a number in it. Anyone
know why and how to prevent?

Thanks.
 
G

Gary''s Student

What you are describing can occur if conditional formatting has been applied
to the cell.
 
S

Stephen

JG Scott said:
I have a range that is all colored yellow. For some reason, one of the
cells changes to white when the user enters a number in it. Anyone
know why and how to prevent?

Thanks.
Click to expand...

Is the cell conditionally formatted? Select the cell and look at
Edit > Format > Conditional formatting
Alternatively, copy a cell that acts as you want, select the 'naughty' cell
and use
Edit > Paste Special > Formats
 
H

hrsni0

I am looking for a conditional formula that will assign a color to the
cell if my condition falls within a certain parameter. Can you tell me
what the conditional formula is in your cell that you are seeing? Thank
you.
 
Top