Conditional Date Formatting

  • Thread starter Thread starter JayD
  • Start date Start date
J

JayD

I have a spreadsheet tracking dated shipments from our suppliers to our

customers.
I am showing the rows for shipments that are due to go out in 7 days
(or less) shaded in red, and those that are 14 days out in green ----

=$A2-TODAY())< 7 ....
=$A2-TODAY()<14.....


Rows for shipments due to go out 6/1 or earlier are shaded green, while

those due on 6/2 are not shaded - which is what I wanted.
Thinking about it, it might be better if the "green" rows (8-14 days
out) could be expanded to include the end of the workweek - in this
case, 6/1 is a Thurs, but it would be better to include 6/2, which is
Friday.
Is there a better function (with arguments) to use in this formula?


Also....
The empty rows at the end of the workbook are all shaded red. Can I add

the condition that
$A2 NOT ='' ?


Thanks.


Jay
 
See response in .programming

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
You must log in or register to reply here.

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

Similar Threads

Conditional Date Formatting 2
conditional formatting 2
Conditional Formatting based on dynamic Date 1
Conditional Formatting 1
Comparison of columns using Conditional Formatting 3
Conditional format Column based on Week Date 2
Easy Question...Conditional formatting? 2
After I reset my Games they get scambled. Conditional Formatting orMacro messed up somewhere 1

Back
Top