Compare with current date change colour

[baskar5353]

How do you find out if the value in a particular cell is a date? Actually I want to run a conditional formatting on cells.i'm having End date in column "E" i want compare the end date with the current date. how to do in VBA

Criteria1:
Content in the cell should be a proper date. It will be in (dd-mmm-yyyy) format

Criteria2:
If the date is 15 days ahead of today's date, color the background cell in RED
If the date is 30 days ahead of today's date, color the background cell in GREEN
If the date is 60 days ahead of today's date, color the background cell in YELLOW
If the date is 61 days ahead of today's date, DO NOT COLOR

 

[Domski]

Any reason why you don't want to do this using normal conditional formatting?

Dom

 

[baskar5353]

each and every day i want to RUN this.If in conditional formatting we can do means can tell me how to do