Solved How do you format all cells displaying a previous date?

October 24, 2019 at 14:03:08
Specs: Windows 10
In Excel:
Using the Conditional Formatting tool, under "A Date Occurring," I only see an option for "Yesterday." Is there a way I can format all cells occurring "Before Today?"

See More: How do you format all cells displaying a previous date?

Reply ↓  Report •

#1
October 24, 2019 at 15:11:31
Try using a formula, something like:

=A1<TODAY()


1) Select your cell or Range of Cells, A1 - A50
2) On the ribbon click Conditional Formatting
3) Click on New Rules, it’s near the bottom of the dialog box.
4) Click Use Formula to determine which cells to format.

5) Enter the formula: =A1<TODAY()

6) Click on the Format button
7) Select the Fill Tab
8) Select a pretty color
9) Click OK
10) Click OK

MIKE

http://www.skeptic.com/


Reply ↓  Report •

#2
October 24, 2019 at 15:18:00
✔ Best Answer
Here is an updated version that does not color a blank cell within the range:

=AND(A1<TODAY(),A1<>"")

MIKE

http://www.skeptic.com/


Reply ↓  Report •
Related Solutions


Ask Question