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

OnePlus 5 review

See the work of famous artists playing with toys

iPad Pro 10.5in (2017) review

Comment faire une capture d’écran sur un Mac ?