Select all the target cells (assuming C2 is the first)

Go to CF

Change Condition 1 to Formula Is

Add a formula of =C2<=TODAY()

Click format

select pattern

choose red

exit

--
HTH

Bob Phillips

"Spiller" wrote in message
...
Hi,

I am trying to compile a spreadsheet for employees on visa's. The table
will
look like this:

Name Type of Visa Expiry Date
Miss X Student 01/09/2005
Mr Y Working 28/12/2005

When a visa is within 30 days of it expiring i want the cell (with the
expiry date in it) to turn orange, when it has reached the expiry date i
want
the cell to turn red. All other dates before this i want to remain in
black.

I have managed to make this work on just one cell (under conditional
formatting) but i need it to work for about 100 employee names.

Can anyone please help me with this query as it is driving me crazy!

Many thanks