Condition formatting a single cell based on multiple others

MiniFav

New Member
Joined
Mar 10, 2020
Messages
20
Office Version
  1. 365
Platform
  1. Windows
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.
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
63,989
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback.
 

Forum statistics

Threads
1,144,370
Messages
5,723,964
Members
422,529
Latest member
mbilal429

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top