Conditional Formating issue.....
 

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?

Conditional Formating issue.....
 

Are you saying that it doe

--

HTH

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


"WalterT." wrote in message
...
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?

Conditional Formating issue.....
 

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)


"WalterT." wrote in message
...
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?

Conditional Formating issue.....
 

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.

"Bob Phillips" wrote:

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)


"WalterT." wrote in message
...
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?