Highlight empty columns in table

[jewsbur0]

Hello all,

I am trying to figure out a way of highlighting columns that don't contain any data in excel. As a example below, how would I be able to highlight the fact the Job column so it shows this column has no data. Tried with a Pivot and conditional formatting but no luck

On a small scale this would be easy, but I have 350 columns to check.

Cheers!


[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Colour[/TD]
[TD]Job[/TD]
[TD]Animal[/TD]
[TD]Age[/TD]
[/TR]
[TR]
[TD]Tom[/TD]
[TD]Blue[/TD]
[TD][/TD]
[TD]Horse[/TD]
[TD]101[/TD]
[/TR]
[TR]
[TD]Barack[/TD]
[TD][/TD]
[TD][/TD]
[TD]Cat[/TD]
[TD]81[/TD]
[/TR]
[TR]
[TD]Lynn[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]95[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Marcílio_Lobão]

jewsbur0, Good morning.

Conditional formatting can to this for you.

Select columns that you want to apply this rule.
Eg. A1:ML1000 (350 COLUMNS)

Menu Conditional Format --> Using formula -->

Type: -->

=COUNTA(A$2:A$1000)=0

Choose Fill color as desired. --> OK

If you prefer instead of selecting initially the range you can use the APPLY TO field at final of Conditional Format, and type:

=$A$2:$ML$1000

Is that what you want?

I hope it helps.