I really like the idea of creating another conditional format. I tried to use the cell function to determine if the cell was manually formatted (ie, filled) then do NOT format. Unfortunately, the cell function does not return if the cell is "filled". Perhaps there is another way to determine...
I created an excel spreadsheet with a conditional format of =MOD(ROW(),2)=1 which sets the fill color on alternating rows to allow for easier horizontal reading. The problem is that if the cell is "shaded" by this conditional format, I cannot manually set the fill color (example, to show...
Whoops PMover,
I think you missed the concept. We are trying to highlight a cell, column, row, etc... when another cell is selected.
For me, I created a vacation calendar with dates going down the left and people's names across the top. When a person selects a cell somewhere in the middle of...