Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting?
I have a sheet that has a formula that calculates the dates of cleanings, i have made a conditional format so that the dates that are coming up and past month are highlighted. I now want to be able to change the conditional format back to normal or another colour when the job is done, is there a way to do it?
Submitted via EggHeadCafe - Software Developer Portal of Choice BizTalk: Conditional looping incorporating the Greater Than functoid. http://www.eggheadcafe.com/tutorials...onal-loop.aspx |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting?
How are you indicating that the job is done? Assuming you're placing a mark
in a cell, your conditional format will prb be something like: =AND(Z2<"Done",YourPreviousFormula) -- Best Regards, Luke M <Jennifer Burch wrote in message ... I have a sheet that has a formula that calculates the dates of cleanings, i have made a conditional format so that the dates that are coming up and past month are highlighted. I now want to be able to change the conditional format back to normal or another colour when the job is done, is there a way to do it? Submitted via EggHeadCafe - Software Developer Portal of Choice BizTalk: Conditional looping incorporating the Greater Than functoid. http://www.eggheadcafe.com/tutorials...onal-loop.aspx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |