conditional formatting

[manickmj18]

I need to highlight a cell in the "D" column if the date is older than 70 days. But... If the cell is blank dont highlight it. Thanks in advance.Mike

[Excel4Everything]

Try to use following formula in conditional formatting:

Please Login or Register  to view this content.

I will make a video to demonstrate this.

[manickmj18]

That didnt work

[Excel4Everything]

Please check the video: http://excel4everything.blogspot.fi/...highlight.html

Hope this helps.

[FDibbins]

Hi and welcome to the forum

1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =AND(D1<>"",D1<=TODAY()-70) format fill as required