Forum Discussion
ryn8985
Dec 17, 2020Copper Contributor
IF function based on dates in cell
Hi - Like many posts, relatively new to excel, though I have some working experience. I'm trying to build a page that would highlight an entire row a certain color if a date is too far removed f...
PCaskey
Dec 17, 2020Copper Contributor
Let's say your Date column is Column A and the data begin in row 2. Let's also figure your table spans columns A thru Z.
In "Conditional Formatting" (Home ribbon), add a New Rule and choose "Use a formula to determine which cells to format". For the formula, use:
=TODAY()-$A2 > {insert # days}
And apply the rule to the entire table (A2:Znn, where nn = last row with data). Note the '$' MUST be in front of the column with the dates and there must be NO $ in front of the row number (2 in this example). Then set the formatting of the conditional format as you like (e.g., pick a "fill" color).