Conditional Formatting - Dates

  daddy3108 19:21 06 Feb 2011

Conditional Formatting - Dates

I am new to using Excel 2007 and am struggling with the new setup.

I have a start date and need to add 15 workdays which I can write a formula for, but the problem is the conditional formatting as I need to achive the following:

the cell needs to change colour through the process as follows 1-4 days needs to be clear, then 5-8 needs to be green, 9-12 can be amber and 13-15 needs to be red.

Can you help?

  johnnyrocker 19:23 06 Feb 2011

you would be better off staying with first posting to save confusion click here


This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Dell XPS 13 9370 (2018) review

The art of 'British' pulp fiction

Best password managers for Mac

TV & streaming : comment regarder le Tournoi des Six Nations 2018 ?