Hi All.
I am trying to conditional format cell A1 Red if any cells below are not empty.
I have tried this many ways only to find that the conditional format only searches up to A2 and ignores the rest of column A.
In my scenario there will be a number of empty cells through out column A and potentially all empty except for row 3000, of which i would like the head to change colour to indicate there is a value to look at, clear the value then double check A2 has change back to its Green colour to tell me not further values of interest are in this column.
The closest i have come is using =AND($A2:$A3000)
This allowed for numeric only values to be picked up and the word TRUE but no other text based values.
Any help on this would be great.
I am trying to conditional format cell A1 Red if any cells below are not empty.
I have tried this many ways only to find that the conditional format only searches up to A2 and ignores the rest of column A.
In my scenario there will be a number of empty cells through out column A and potentially all empty except for row 3000, of which i would like the head to change colour to indicate there is a value to look at, clear the value then double check A2 has change back to its Green colour to tell me not further values of interest are in this column.
The closest i have come is using =AND($A2:$A3000)
This allowed for numeric only values to be picked up and the word TRUE but no other text based values.
Any help on this would be great.