Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Conditional formating using formulas | Excel Worksheet Functions | |||
can i freeze conditional formating to copy to another worksheet | Excel Discussion (Misc queries) | |||
VLOOKUP & Conditional Formating Help. | Excel Discussion (Misc queries) | |||
more than 3 conditional formating in excel | Excel Discussion (Misc queries) |