conditional formatting?


Jennifer Burch

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.



Luke M

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:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question