CALC & Conditional Formal (single column vs multiple columns)

JG101 · February 15, 2025, 6:26pm

How do i apply conditional (3 color) format for one column and then duplicate that conditional format to all columns without the conditional format combining all columns with the same conditional format.

the only current work-around for me at the moment is to high-light each column separately and apply the conditional format for each column. I have 300 columns within 5 different tabs (1500 columns), this will take way to long to individually set a conditional format for each column.

is there a better way?

Thank U in advance for any info/help provided.

AC1:AC1048576: the original conditional format with one column

When i attempt to highlight multiple columns to apply the same conditional format, all columns are combined (which is expected due to highlighting multiple columns) but i do not want the conditional format to be combined.

I’m attempting create separate ranges for each column and applying within the window, but again this will take some time.

H11:H1048576,J11:O1048576,J1:O9,H1:H9: when i highlight columns to past conditional format this is what appears and it will combine all the highlighted columns for that conditional format.

karolus · February 15, 2025, 6:35pm

For further help you should tell at least the three conditions for one column … eg AC1:AC1048576

JG101 · February 15, 2025, 7:42pm

i do not follow what ur saying…

AC1:AC1048576 <— i posted this above as the original conditional format column,

the conditional format I would like to copy from AC1:AC1048576 and apply / paste to other columns without the columns combining the conditional format as AC1:AB1048576 when i highlight the columns.

i can do this… AC1:AC1048576, AD1:AD1048576 , this would apply the conditional format separately to each column, BUT i would have to manually input each column myself, is there a better way.

and i’m attempting to do the above but now its is difficult to remove each SPACE between each character. AC 1 : AC 1048576

I’m placing AC (A1) 1 (B1) : (C1) AC (D1) 1048576 (E1) and it looks like: AC 1 : AC 1048576
so i can quickly create 300 of them, but “spaces” remain and the Cell Range does not accept any spaces.

i have tried: TRIM(), SUBSTITUTE(), and CLEAN() to remove the spaces, and nothing is working

also attempted to “merge” cells, it worked but spaces remain and not able to remove

karolus · February 15, 2025, 7:48pm

WHICH Condition[s] did you apply??

JG101 · February 15, 2025, 8:45pm

highlight column/rows: AC1:AC1048576
apply a conditional format (3 colors) or whatever the user desires
now copy AC1:AC1048576 conditional format and apply to other columns by paste - paste special - formats only
if applying to individual columns it works great
i do not have the time to apply to each column manually (i have 1500 columns), i was hoping there was a way when i highlight all the columns and apply the copy/paste format only it would set the conditional format to each column and NOT combine the conditional format to all 1500 columns)

see pictures
conditional format: individual for each columns