Excel 2013 - Data Bar Conditional Formatting in Pivot Tables 1

[beadedbytes]

Is there an easy way to assign like-colored data bars in 'one fell swoop' inside a pivot table? In other words, can columns that are to be colored orange be assigned at the same time?

When I created the example below the first time, I did it for each individual column. I've attempted to select the non-contiguous columns, but have not had any success with the end result. (FYI ... I want to be able to do this w/o including the total or subtotal lines.)

Col_A	Col_B	Col_C	Col_D	Col_E	Col_F	Col_G	Col_H
Orange	Blue	Yellow	Green	Orange	Blue	Yellow	Green

 

[SkipVought]

Hi,

Don't believe so.

I found that I could Selec non-contiguous rows, not columns.

 

[beadedbytes]

Thanks, Skip, for confirming. I still have not found a solution after trying many options.