Conditional formatting and row highlighting

  • Thread starter Thread starter Cary
  • Start date Start date
C

Cary

I have an extensive list of T-Bills.

I would like to highlight those rows where the Maturity Date was before
today.

I can do this for those dates in Maturity Date column that meet this
criterion using the conditional format db. But How can a go a step
further and have the entire row highlighted?

Thanks
 
Say the "row" you're talking about is A:K, with your date of maturity
located in Column G.

With Row1 as a header row, select A2 to K100, then:
<Format> <ConditionalFormat>,
click "Formula Is", and enter this:

=$G2<TODAY()

Click on "Format", and choose the color of your Pattern, then <OK> <OK>.

Be advised, that any row where Column G is empty (less the today), will
highlight.
 
Ragdyer said:
Say the "row" you're talking about is A:K, with your date of maturity
located in Column G.

With Row1 as a header row, select A2 to K100, then:
<Format> <ConditionalFormat>,
click "Formula Is", and enter this:

=$G2<TODAY()

Click on "Format", and choose the color of your Pattern, then <OK> <OK>.

Be advised, that any row where Column G is empty (less the today), will
highlight.
Click to expand...

Worked like a charm. Thanks!
 
Thanks for the feed-back.

BTW,
If you would like your *empty* rows to *not* highlight:

=AND($G2<TODAY(),$G2<>"")
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------


Ragdyer said:
Say the "row" you're talking about is A:K, with your date of maturity
located in Column G.

With Row1 as a header row, select A2 to K100, then:
<Format> <ConditionalFormat>,
click "Formula Is", and enter this:

=$G2<TODAY()

Click on "Format", and choose the color of your Pattern, then <OK> <OK>.

Be advised, that any row where Column G is empty (less the today), will
highlight.
Click to expand...

Worked like a charm. Thanks!
 
Back
Top