Conditional Formatting formula

[Oh!Calcutta]

Dear All,

I want to have a formula/VBA Code for my data described as below:

Col A date (dd/mm/yyyy) with the oldest date being 01/04/2009
Col B amount due from customers
Col C name of customers

I want to colour cells in red/blue of Col A when the date is 3 to 5 years old and corresponding Col B amount & Col C customer name should also be formatted in the same colour as in Col A.

Please help.

Thanks in advance.

Oh!Calcutta

 

[etaf]

use conditional formatting

=AND($A1>=DATE(YEAR(TODAY())-5,MONTH(TODAY()),DAY(TODAY())), $A1<=DATE(YEAR(TODAY())-3,MONTH(TODAY()),DAY(TODAY())))
should be able to apply to column A, B, and C
and down the rows

what version of excel do you have

what do you mean by

I want to colour cells in red/blue

 

[Oh!Calcutta]

use conditional formatting

=AND($A1>=DATE(YEAR(TODAY())-5,MONTH(TODAY()),DAY(TODAY())), $A1<=DATE(YEAR(TODAY())-3,MONTH(TODAY()),DAY(TODAY())))
should be able to apply to column A, B, and C
and down the rows

what version of excel do you have

what do you mean by

I'm using Excel 2007.

I want fonts & cell borders to be coloured in red/blue.

Thanks

 

[etaf]

I created a file with the conditional format added

but cannot attach

the above will work and you can format borders and fonts