Cell changes color

[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.

 

[Guest]

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

 

[Stephen]

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.

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

 

[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.