Vlookup Function Needed

[Marcopolo]

Hi,

I was wondering if anyone could help me sort out my problem. I have
spreadsheet with around 15 sheets on it. I have a Vlookup sheet whic
provides todays date and is updated daily automatically.

In each of the other sheets I have an end of maintenance column whic
has a list of dates. What I need is a formula for the i
progress/finished column. The purpose of this column is to check if th
date in the end of maintenance column is greater than the date shown i
the lookup sheet. If it is then "finished" shall appear in black. I
however, it is before the date shown in the lookup sheet then it shoul
appear in red and display "in progress".

Here is the formula I have so far. It displays the messages ok but ho
do I go about displaying them in a certain colour?

=IF(+LOOKUP!$B$2>+L3,"FINISHED","IN PROGRESS"

 

[Frank Kabel]

Hi
you may use conditional format:
- select the cell
- goto 'Format - Conditional format'
- choose cell = 'OK' and select your format for this condition

Repeat this for the other conditions (up to three)