I don't have Excel on this machine I am using at the moment so I can't test this myself, and I only use XP 2002 anyway, but I am sure this is possible.
I'm guessing you know what Conditional Formatting is, and where to find it in Excel, so I won't attempt to tell you that.
Conditional Formatting allows the selected cell to be color formatted when certain conditions are met, and those conditions do not have to relate to that selected cell itself.
For example, I have a spreadsheet that I use to monitor share price movement. On my main page I have a group of cells that normally do not display anything, (white font on white background cells). However, if the shares I am monitoring drop below a certain %age of a fixed amount these cells display a Red warning, (black font on red background) to tell me that something is happening. I have another cell or group of cells that calculate the %age drop and it is those that the conditioned cells look at.
It took me a while to do it, but I got it right in the end.
So, not just "I think" it would work, it will work.
Mark
Hi,
I would like to create a grid for a user to input some employee related data, x rows, 12 columns (Jan - Dec)
The tricky part is there will be two prior columns with a starting date, and a leaving date which will be either blank or have a value.
What I want to do in the input section, is have any cell that relates to a month when an employee has not yet started, or has already left, display as one colour, and the remainder of the cells in another.
So as to try to guide users not to put data in the wrong cells.
I can't pre set the colours or use cell protection, because I don't know what dates they will complete in the first two columns.
Any one got any thoughts on this ?
Robert

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic