Conditional formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mcgrath383 - 20 Oct 2007 15:33 GMT

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?

Reply to this Message

Gord Dibben - 20 Oct 2007 16:17 GMT

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

>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?

Reply to this Message

mcgrath383 - 21 Oct 2007 11:25 GMT

> Have you tried and failed or?
>
[quoted text clipped - 14 lines]
> >column that i want to select is 6 columns apart?
> >Any suggestions?

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

=-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?

Reply to this Message

Gord Dibben - 21 Oct 2007 15:22 GMT

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

>> Have you tried and failed or?
>>
[quoted text clipped - 27 lines]
>
>thanks for your response, is this any clearer?

Reply to this Message

mcgrath383 - 11 Nov 2007 16:47 GMT

> Perhaps your data is not exactly what you think it is.
>
[quoted text clipped - 39 lines]
>
> >thanks for your response, is this any clearer?

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

Reply to this Message