Applying conditional formatting rule to multiple columns on different sheets

[sgcannon]

I have a bunch of conditional formatting rules that apply to various columns on my master sheet. But I've added more sheets and want to apply those same rules to columns on the other sheets. Of course I could duplicate the rules and change the "applies to" to point to the right column on the new sheet but if I ever wanted to change the conditional formatting rule I'd have to go to mulitple different rules, changing each one individually.

It seems like I ought to be able to go to the "applies to" and either use commas to add additional columns or hit the up arrow and select other columns by clicking on them while holding the control button. When I do either of these things I can see the new columns in the "applies to" box but as soon as I hit OK or Apply, the "applies to" goes back to the first original column on the first sheet and deletes the addition columns I had been trying to apply the rules to.

Thanks for your help!!

Steve

 

[etaf]

i'm sure other members may have an answer , i do not know of one , maybe using some VBA code , which i dont do
What version of excel are you using - update your profile with the version this needs to apply to

You can copy and paste special - Format - That will change the format of the cell as well as copy over the conditional formatting to the new sheet - so may not be exactly what you want

to copy the entire sheet - click on the small square between the COLUMN A and ROW 1
that selects the entire sheet
Now click on A1 in the new sheet
Paste Special > Format

 

[sgcannon]

That's good to know, but in this case I'm trying to apply it to just one column, not the whole sheet.

It's weird because I can definately apply the rule to more than one column, but only if it's on the same sheet.

 

[etaf]

That's good to know, but in this case I'm trying to apply it to just one column, not the whole sheet.

then just click on the column header "letter" and that will select the entire column and copy - click on column row1 and then Paste Special - Formats

t's weird because I can definately apply the rule to more than one column, but only if it's on the same sheet.

thats normal you can apply to any range on a sheet , no restriction I know of for a sheet
even whole column references A:A etc

you can reference a cell in another sheet
so select day column A of sheet1
and use a formula
=Sheet2!A2<5
and if values of less than 5 are entered into A2 etc , it will colour sheet1 based on sheet2 values

 

[sgcannon]

then just click on the column header "letter" and that will select the entire column and copy - click on column row1 and then Paste Special - Formats

thats normal you can apply to any range on a sheet , no restriction I know of for a sheet
even whole column references A:A etc

you can reference a cell in another sheet
so select day column A of sheet1
and use a formula
=Sheet2!A2<5
and if values of less than 5 are entered into A2 etc , it will colour sheet1 based on sheet2 values

Thanks!!

 

[etaf]

you are welcome