RyansPlace
New Member
- Joined
- Dec 19, 2009
- Messages
- 25
Hello,
I'm using Microsoft Excel 2003. I have a spreadsheet to log missions with several columns (column ID and title below):
B5:999 'PZ', C5:999 'Pickup', D5:999 'DZ', E5:999 'Destination'.
My intent is to have the 'Pickup' column highlight in red if there is no input in the 'PZ' column, but then revert to its original color once an entry is made in in the 'PZ' column.
Additionally, I'd like to have the 'Destination' column highlight in red when an entry is made in the 'PZ' column, but then revert to it's original color when an entry is made in the 'DZ' column.
Only input made in the 'PZ' and 'DZ' columns are X's indicating that portion of the mission was completed.
I'm familiar with the Conditional Formatting menu, but is only seems to look at a single cell. I'm trying to use multiple criteria to change the color of a cell based on input in adjacent cells. Can this be done?
v/r
-Ry
<input id="gwProxy" type="hidden"><!--Session data--><input *******="if(typeof(jsCall)=='function'){jsCall();}else{setTimeout('jsCall()',500);}" id="jsProxy" type="hidden">
I'm using Microsoft Excel 2003. I have a spreadsheet to log missions with several columns (column ID and title below):
B5:999 'PZ', C5:999 'Pickup', D5:999 'DZ', E5:999 'Destination'.
My intent is to have the 'Pickup' column highlight in red if there is no input in the 'PZ' column, but then revert to its original color once an entry is made in in the 'PZ' column.
Additionally, I'd like to have the 'Destination' column highlight in red when an entry is made in the 'PZ' column, but then revert to it's original color when an entry is made in the 'DZ' column.
Only input made in the 'PZ' and 'DZ' columns are X's indicating that portion of the mission was completed.
I'm familiar with the Conditional Formatting menu, but is only seems to look at a single cell. I'm trying to use multiple criteria to change the color of a cell based on input in adjacent cells. Can this be done?
v/r
-Ry
<input id="gwProxy" type="hidden"><!--Session data--><input *******="if(typeof(jsCall)=='function'){jsCall();}else{setTimeout('jsCall()',500);}" id="jsProxy" type="hidden">