Conditional Formatting

  • Thread starter Thread starter wmjenner
  • Start date Start date
W

wmjenner

Is there any way to use conditional formatting where the condition to be
met is in another cell other than the current one?

I want to "flag" certain production orders as being top priority over
others. So, in cell A1 I have the production quantity and in cell B1
I have a work order number. In cell X1, I am looking up the due date
of the production work order from another spreadsheet and if it is <
than this week's starting date, I want B1 to change color or whatever.

Here's an example: Production Week of 8/30/04

A B ....... X
1 50 10854 7/30/04

The due date is 7/30 which is less than the current production week
(meaning the order is past due) so I want the work order number (10854)
to change color so the production people know it's a higher priority
than the others. Any way to do this?

Many thanks in advance!
 
Hi
try the following:
- select cell B1
- open the conditional format dialog and enter the following formula:
=X1<TODAY()-WEEKDAY(TODAY(),3)
- choose your color
 
Back
Top