How do I conditionally format dates so that "expired" dates highl.

[Guest]

I am trying to format a spreadsheet that contains "date" information, trying
to track when things "expire". I want to conditionally format the data, such
that dates prior to "today" highlight in red. I tried using "less than, but
equal to" =&[date}, but all dates are being highlighted in red.

 

[JulieD]

Hi

select the first cell that you want to apply conditional formatting to (i'm
assuming A1) and then choose
format / conditional formatting
choose formula is
type
=$A1<=TODAY()
choose the format
press ok
copy the conditional formatting to the other cells (I use the format
painter - big yellow paint brush - click on A1, click on format painter,
drag over other cells).

Hope this helps
Cheers
JulieD

 

[Guest]

Thank you for the advice. I was trying to perform the conditional formatting
by selecting the entire range of columns that contain the data, then
performing the conditional formatting. In your solution, the conditional
formatting is done in one cell first, then copied to the other cells. I
guess it can't be done on a wholesale basis, which is fine.

Hi

select the first cell that you want to apply conditional formatting to (i'm
assuming A1) and then choose
format / conditional formatting
choose formula is
type
=$A1<=TODAY()
choose the format
press ok
copy the conditional formatting to the other cells (I use the format
painter - big yellow paint brush - click on A1, click on format painter,
drag over other cells).

Hope this helps
Cheers
JulieD

I am trying to format a spreadsheet that contains "date" information,
trying
to track when things "expire". I want to conditionally format the data,
such
that dates prior to "today" highlight in red. I tried using "less than,
but
equal to" =&[date}, but all dates are being highlighted in red.

 

[JulieD]

Hi

it actually can be done at once, but you have to ensure that the row that
you're starting the conditional formatting on is the first row at the top of
the screen .. which gets messy when you try to explain it in a newsgroup ..
this other method takes half a second more and doesn't involve any messy
explainations.

Cheers
JulieD

Thank you for the advice. I was trying to perform the conditional
formatting
by selecting the entire range of columns that contain the data, then
performing the conditional formatting. In your solution, the conditional
formatting is done in one cell first, then copied to the other cells. I
guess it can't be done on a wholesale basis, which is fine.

Hi

select the first cell that you want to apply conditional formatting to
(i'm
assuming A1) and then choose
format / conditional formatting
choose formula is
type
=$A1<=TODAY()
choose the format
press ok
copy the conditional formatting to the other cells (I use the format
painter - big yellow paint brush - click on A1, click on format painter,
drag over other cells).

Hope this helps
Cheers
JulieD

I am trying to format a spreadsheet that contains "date" information,
trying
to track when things "expire". I want to conditionally format the data,
such
that dates prior to "today" highlight in red. I tried using "less
than,
but
equal to" =&[date}, but all dates are being highlighted in red.