Geek Answers Handbook

Format cell if cell contains date less than today

I am trying to get conditional formatting for a row when the cell in this row contains a date that is less than or equal to today (yesterday, today, last week, etc.).

I tried =IF($W$4,TODAY()) , which works if the cell is equal to today's date, but I cannot figure out how to make it work if the cell is equal to today or less than today.

Also, is it possible to copy this conditional formatting to work for each cell in the column, but only affects the cell row? In addition, this cell remains lit if it is left empty, is this true? like =IF(ISBLANK()),IF($W$4<=TODAY())

+7
excel conditional-formatting
source share
2 answers

Your first problem was that you used the comparison characters incorrectly.

 < less than > greater than <= less than or equal to >= greater than or equal to

Answer other questions; get a condition for working on each cell in a column and what to do with spaces?

What about spaces?

Add an additional IF condition to check if the cell is empty or not, if it is not empty, do a check. =IF(B2="","",B2<=TODAY())

Condition for each cell in a column

enter image description here

+10
source share
 =$W$4<=TODAY()

Returns true for dates before and inclusive today, false otherwise.

+3
source share

More articles:


All Articles