Prev: @Count
Next: Changing coler of tracking cells
From: Jennifer on 7 Apr 2010 13:55
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/aspnet/e4334816-d106-40f2-812d-043c18df964c/biztalk-conditional-loop.aspx
From: Luke M on 7 Apr 2010 15:47
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 news:201047135542jenniferburch(a)live.ca...
>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/aspnet/e4334816-d106-40f2-812d-043c18df964c/biztalk-conditional-loop.aspx


 | 
Pages: 1
Prev: @Count
Next: Changing coler of tracking cells