conditional formatting date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm in a spreadsheet with a lot of data and two of my conditional formatting
options are already used, so I only have one left.
I would like rows that have a due date of today or earlier to be green but
all others stay the way they are (i.e. black).
When I enter "formal is = $T1<TODAY()" I get cells that are green even if
they are blank. I don't want the blank ones to turn green. Is there some sort
of ignore blank statement I can use with it?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top