| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
THANK YOU! works like a dream.
"Luke M" wrote: With cell A1 Condition1: "Formula is" =ISNUMBER(B1) Set formatting to fill blue Condition2: "Cell value is equal to": "yes" Set formatting to yellow fill Condition3: "Cell value is equal to": "no" Set formatting to grey fill -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "bettyh" wrote: Excel XP I have 2 columns First in A1 formatted to yellow fill if the value is "yes" and grey if value is "no" I have that done. No Problem Cell B1 is set to fill grey if the value of A1 is "no" and blue if A1 is "yes" Have that done, no problem. Now, I want to add a condition to A1 that will change the formatting to fill in blue if there is a date (any date) in B1. Goal is to highlight follow up tasks, then, when done create a blue fill to be able to easily follow a trail of tasks done in the spreadsheet wich notes all client contact whether it needs follow up or not. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
| Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
| Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Threaded Mode
