Conditional formatting

  • Thread starter Thread starter mcgrath383
  • Start date Start date
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?
 
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
 
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?
 
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
 
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
 
Back
Top