| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do i make a range of cells change colour
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| Adding colour to a range of cells based on one of the cells v... | Excel Discussion (Misc queries) | |||
| how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) | |||
| how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
| How do I change an Excel range of cells from relative to absolute. | Excel Worksheet Functions | |||
Threaded Mode
