Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting and IF
How can I turn a condition off or on?
If current cell has a value then the format is white font, blue background .....if cell A1 = "yes" If current cell has a value then the format is blue font, blue background .....if cell A1 = "no" Format is white font, white background if no value |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting and IF
Dont understand the question. which cell is current, what's in A1 and in
which cell you need this formatting? "Saintsman" wrote in message ... How can I turn a condition off or on? If current cell has a value then the format is white font, blue background ....if cell A1 = "yes" If current cell has a value then the format is blue font, blue background ....if cell A1 = "no" Format is white font, white background if no value |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting and IF
Go to FormatConditional Formatting, click Delete, tick all conditions, and
OK out. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Saintsman" wrote in message ... How can I turn a condition off or on? If current cell has a value then the format is white font, blue background ....if cell A1 = "yes" If current cell has a value then the format is blue font, blue background ....if cell A1 = "no" Format is white font, white background if no value |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional formatting | Excel Worksheet Functions | |||
Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |