Dates + Conditional Formatting

[bluenose76]

Hi,

I hope that someone out there can help me with this

I have a Spreadtsheet with dates in column E. What i need is for the cell to change colours based on age

for example, if more than 18 monthes have passed then it changes red

If it is only 12 monthes then it changes yellow and less that 12 monthes it remains white

i have tried lots of solutiong but cant gte it to work for me

PLEASE help

Regards
Bev

 

[HaHoBe]

Hi, Bev,

have you tried a go with Conditional Formatting? You could use a constant values instead of building the date by formula.

Ciao,
Holger