Conditional Formating issue.....

[Guest]

I have a CF set up for a row:
=$D$12="Billable" then green back ground, and if non-billable then blue. The
colours are reversed based on selection and when I type in the box the colour
goes away. Any help?

 

[Bob Phillips]

Are you saying that it doe

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Bob Phillips]

Are you saying that it doesn't work, or that is what you want to work. Your
question is not clear to me.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

I am saying that the formating changed the color the way I wanted it to but...
f1 if d12=billable make cell background green
f2 if d12=non-billable make cell background blue.
The background colours change but backwards (billable turns blue, and
non-billable turns green).
When I enter text in the cells the background colours go to white. I want
them to stay the colour based on d12.