conditional formatting using forumlas??

  • Thread starter Thread starter watfordone
  • Start date Start date
W

watfordone

I am trying to use conditional formatting to highlight two things in my
order process:
1) To highlight when I only have a week to get an order out
2) To highlight when the order dat is passed but the order is not yet
complete

I've managed the first task. However I need to write a formula which
says something like:
"If the order date is overdue (i.e. if order date (D2) is more than
TODAY(B2)) highlight RED unless the order is completed (i.e unless
Order Out To Date (C2) = Overall Order Amount (C5)) in which case stop
highlighting"

This might sound a bit complex but I really need help.

Thanks x x
 
Hi,
I've attached a simple worksheet, that has an example of how, what
think you want, can be done. I've had to add an intermediate cel
called "overdue indicator" to get things to work. Take a look and se
if you can make it work in your spreadsheet.

Regards,
Case

Attachment filename: conditional formatting.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=40766
 
watfordone
Use the following formula as your condition

=AND(D2>TODAY(),C2<>C5

You might need to play with the reference styles (abs./rel.) if you need to copy the formatting to other cells

Good Luck
Mark Graesse
(e-mail address removed)

----- watfordone > wrote: ----

I am trying to use conditional formatting to highlight two things in m
order process
1) To highlight when I only have a week to get an order ou
2) To highlight when the order dat is passed but the order is not ye
complet

I've managed the first task. However I need to write a formula whic
says something like
"If the order date is overdue (i.e. if order date (D2) is more tha
TODAY(B2)) highlight RED unless the order is completed (i.e unles
Order Out To Date (C2) = Overall Order Amount (C5)) in which case sto
highlighting

This might sound a bit complex but I really need help

Thanks x
 
Back
Top