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?
|