conditional formatting using forumlas??

[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

 

[Casey]

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]

Thanks to everyone who helped me.

It worked a treat. Nice one.

x x