Alright here is what I'm doing.
I have 4 worksheets, the top being a cover sheet
Using conditional formatting I want a range of cells on the front page to highlight if the corresponding cell on one of the other cells is filled in.
On the front sheet I'm using the following (or something similar):
=NOT(ISBLANK(Sheet3!C4:C9))
The formula is working in some columns but doesn't work for the values in the C and D columns on the front sheet.
I moved the formula calling the same cells but in the A and B columns and it works correctly.
Can anyone explain why the formula is not working in the C & D columns and how to fix it?
I have 4 worksheets, the top being a cover sheet
Using conditional formatting I want a range of cells on the front page to highlight if the corresponding cell on one of the other cells is filled in.
On the front sheet I'm using the following (or something similar):
=NOT(ISBLANK(Sheet3!C4:C9))
The formula is working in some columns but doesn't work for the values in the C and D columns on the front sheet.
I moved the formula calling the same cells but in the A and B columns and it works correctly.
Can anyone explain why the formula is not working in the C & D columns and how to fix it?