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