Conditional Formatting - Dates

  daddy3108 19:21 06 Feb 11

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 11

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.

The Legend of Zelda Breath of the Wild review: Five hours with Zelda on the Nintendo Switch

1995-2015: How technology has changed the world in 20 years

How the painting-like animated sequences in A Monster Calls were created by Glassworks Barcelona

The 22 best Safari extensions | Best Safari plugins: Improve Apple's Safari web browser with these…