Higlight rows

[azael2k]

Hi guys. I'm a total noob when it comes to excel macro. However i find myself in need of a macro that will highlight an entire row a certain color when "Date" cell is older than 4 days. Perhaps someone will be kind enough to help me build it.

Thank you all.

 

[alansidman]

Conditional formatting will do this for you. VBA is not required.

https://www.ablebits.com/office-addins-blog/2014/06/17/excel-conditional-formatting-dates/

 

[azael2k]

Conditional formatting will do this for you. VBA is not required.

https://www.ablebits.com/office-addins-blog/2014/06/17/excel-conditional-formatting-dates/

Thank you for the answer. The thing is I have a table with 2 columns of dates (last date of referral and last date of contact)where I need to do the following:
Last referral was 30 days ago or more, on day 30 highlight blue
Last contact was 30 days ago or more, on day 30 highlight yellow
Both were 30 days ago or more, on day 30 highlight everything green

While I managed to use your link and make the first two work, I can't seem to make the last one work for the love of me. Any formula I apply, it just highlights randomly. Basically, what I need is, if the difference between today and D column is bigger or equal than 30 day AND if the difference between today and E column is bigger or equal to 30 days ON THE SAME ROW, I need everything highlighted green (not only the D and E cells that comply but the whole row where D and E have those values simultaneously). So I need a formula or something that highlights green if both happened 30 days ago for a name, which is in column A. You can see the image of what I'm trying to do here https://prnt.sc/l2h2dp - Thank you!

 

[Fluff]

Select the rows you're interested in and use this formula
=AND($E2<(TODAY()-30),$F2<(TODAY()-30))
This assumes that the first row you selected is row 2