Conditional Formatting with Dates

Question

How do I format so that certain adjacent cells will highlight if one of the cells is before current date.&nbsp;B4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;C4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;D4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; E4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; F44&nbsp; &nbsp; &nbsp; BYRON LAKEVIEW NURSERY, LLC&nbsp; &nbsp; &nbsp; JONATHAN D. JAMES&nbsp; &nbsp; &nbsp; 39401&nbsp; &nbsp; &nbsp; &nbsp;4/11/2016&nbsp;I Need these cells to highlight to yellow if F4 is before today's date.&nbsp;How do I do this in conditional formatting?

subodh_tiwari_sktneer · Answer

MiMiMarie&nbsp;Select B4:F4 and make a New Rule for Conditional Formatting using the formula given below and set the format as per your choice.&nbsp;=$F4&lt;TODAY()

Forum Discussion

Conditional Formatting with Dates

1 Reply

Resources