Change font and cell fill depending upon difference in days between two date columns

[Geoffo123]

Hello, another question. On my worksheet I have a cloumn headed 'received date' and a second column headed 'completed date'. Each row represents a project quotation. So, in row 1 project A was recieved on the first of November 2012 (01/11/2012), in the next cell to the right (second column) I would input the date when this quotation was completed.

If the difference between these dates is greater than 7 days, what function/formula would I use to make the font in the same row of both columns turn red. Same question again, but more than 10 days the font is bold red on a light red fill. Same question again but less than 7 days is green font.

My last question posted here, was solved within the hour - I couldn't ask for better service.
I wait patiently for your answers

Geoff

[jkj115]

use this formula in conditional formatting

Please Login or Register  to view this content.

[jkj115]

but anchor the columns. You can apply same formula for the other formatting you want.

Please Login or Register  to view this content.

[Geoffo123]

Att jkj115, I'm using excel 2010. Can you please tell me how to use this formula in conditional formatting? Thank you for your time, this forum is great for assissting noobs like myself get ahead.
Cheers

[benishiryo]

hi Geoffo123. highlight the cells you need from top left to bottom right & go to Home -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format -> Format values where this formula is true:
assuming A2 & B2 are the Received & Completed Dates then use this formula:
=($B2-$A2)>7
go to "Format" & do the necessary colouring

or the rest, just repeat the above step & do these formulas:
=($B2-$A2)>10

=($B2-$A2)<7

[Geoffo123]

Hi all, for some reason, it has stopped working. Although when I go to conditional formatting, manage rules, it is still there. I was wondering if there was any other way to do this. I have inserted a snip pic of the actual worksheet,
excel snip.jpg
as you can see, it concerns only the recieved column and the completed column. This is only per my reference, as i like to see where and why certain items take longer in order to improve.

Any assistance here would be very much appreciated
Cheers, Geoff