Condition formatting a single cell based on multiple others

[MiniFav]

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.

 

[Fluff]

How about

=COUNTA(A2:A3000)>1

 

[MiniFav]

How about

=COUNTA(A2:A3000)>1

Thank you for the quick reply!
This just makes A1 turn red even with blanks. I will try to use this suggestion along with an IF and see if i can get that to work.

I forgot to mention, all the blank cells below A! have formulas which are error checking another worksheet, thats where this table populates and shows any errors for me to fix.
Rather than scrolling through 3000 rows or filters i would just like the very top cell to change colour as a quick indicator of if i have any work to correct.

 

[Fluff]

I thought you wanted to highlight A1 if any cells from A2:A3000 were not blank, but that A3000 would always have a value. Is this not the case?

 

[MiniFav]

I thought you wanted to highlight A1 if any cells from A2:A3000 were not blank, but that A3000 would always have a value. Is this not the case?

Sorry no. There is a chance that range A2:A3000 will be completely blank. in this case i would like A2 to turn green to indicate i have no errors to resolve.
Then A2 to turn red if there are any values withing range A2:A3000 indicating i have issues to fix.

 

[Fluff]

In that case use

=COUNTA(A2:A3000)>0

 

[MiniFav]

In that case use

=COUNTA(A2:A3000)>0

This is still turning A1 red even though there are no values in A2:A3000. I have narrowed this down to it picking up the formulas i have in range A2:A3000 even though they are returning blanks ""

I have used the following to try and ignore the formulas but i am coming back to the same issue that this only works as far as A2 and then no further.
=IF((A2:A3000)="","",IF(COUNTA(A2:A3000)>0,TRUE,""))

 

[Fluff]

Do those formulae return text or numbers?

 

[MiniFav]

Could return both/ mix of

 

[Fluff]

In that case try

=COUNTIFS(A2:A3000,"")<>2999