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?

Are you saying that it doe

--

HTH

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


"WalterT." <WalterT@discussions.microsoft.com> wrote in message
news:A6989E8E-CC8E-4BAC-9877-78E0037F4C90@microsoft.com...
> 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?

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." <WalterT@discussions.microsoft.com> wrote in message
news:A6989E8E-CC8E-4BAC-9877-78E0037F4C90@microsoft.com...
> 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?

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." <WalterT@discussions.microsoft.com> wrote in message
> news:A6989E8E-CC8E-4BAC-9877-78E0037F4C90@microsoft.com...
> > 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?
>
>
>