ExcelBanter - conditional formatting a date

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - conditional formatting a date (https://www.excelbanter.com/excel-discussion-misc-queries/214088-conditional-formatting-date.html)

Neilvass

conditional formatting a date

How do i make a cell change colour
a) if the date entered in it has passed
B) if it is before that date

Max

conditional formatting a date

How do i make a cell change colour
a) if the date entered in it has passed

Select the range, eg select A2:A10 (A2 active),
then apply CF using Formula Is:
=AND(A2<TODAY(),A2<"")
Format to taste OK

The additional check: A2<""
is to prevent blank cells (if any) from spuriously triggering the CF
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik
---

All times are GMT +1. The time now is 02:38 PM.