Conditional formatting

M

mcgrath383

can i select multiple columns at once so i can apply conditional
formatting to all of them at once rather than individually. each
column that i want to select is 6 columns apart?
Any suggestions?
 
G

Gord Dibben

Have you tried and failed or?

Could depend upon cell references if using Formula Is:

Select B, G and L and Format>CF>Formula is: =$A1="qwerty"

Works OK for me because $A is a fixed column reference

A1 would get all messed because it is relative.

Or Equal to 67 works fine also.


Gord Dibben MS Excel MVP
 
M

mcgrath383

Have you tried and failed or?

Could depend upon cell references if using Formula Is:

Select B, G and L and Format>CF>Formula is: =$A1="qwerty"

Works OK for me because $A is a fixed column reference

A1 would get all messed because it is relative.

Or Equal to 67 works fine also.

Gord Dibben MS Excel MVP
Click to expand...

I have tried slecting different columns at the same time but no
luck!!! i have tried using ctrl and shift seperately and together but
it just selects all the columns in the range.
The actual formatting is fairly straight forward.
i have three conditions
= 0 then turn box green
Click to expand...
=-1 then turn box yellow
<-1 then turn box red
I need to apply this to about twenty columns all in all but want a
quick way rather then doing each individually.

thanks for your response, is this any clearer?
 
G

Gord Dibben

Perhaps your data is not exactly what you think it is.

0 can be 0.00000000000123 but formatted to display 0

Experiment on a new sheet with exact numbers, not those derived from formulas.

I inserted a new sheet and selected 10 non-adjacent columns using CTRL + click
and worked OK when I input exact numbers like -1 and -2..............all blank
cells are "0" in Excel's mind.


Gord
 
M

mcgrath383

Perhaps your data is not exactly what you think it is.

0 can be 0.00000000000123 but formatted to display 0

Experiment on a new sheet with exact numbers, not those derived from formulas.

I inserted a new sheet and selected 10 non-adjacent columns using CTRL + click
and worked OK when I input exact numbers like -1 and -2..............all blank
cells are "0" in Excel's mind.

Gord
Click to expand...

thanks for this suggestion
in the end i applied the format to one column and then copy and paste
to the others
cheers
paddy
 
Top