Multiple row formatting

[kshah2k4]

Hello,

I am trying to set conditional formatting for multiple rows. Basically what needs to happen is that based on the value (between 1-20) in column G a whole row will be formatted with a specifit colour.

i tired the "formula below" but cannot figure out how to get it to apply to multiple rows. it only seems to work for one row

Select the whole row. Select FORMAT --> CONDITIONAL FORMATING change Cell Value is to Formula is
and enter =$G$G=1 and then set the colour i want to format.

If i select a specific cell like G$18=0 it fors for row 18 but not for any other row.

any ideas?

thanks

Kevin

 

[Domski]

Your formula in the first row's (row 1 in this example) conditional format needs to be:

=$G1=1

You can then select that row, copy it and paste values to the other rows.

 

[Domski]

Sorry I mean Paste Special... Formats not paste values

 

[kshah2k4]

ok, that worked, you are awesome,

BUT, conditional formatting only allows for 3 conditions. I need to set 20 different conditions. Any ideas?

thanks again

Kevin

 

[Domski]

It is a bit limiting. You're heading into the realm of visual basic there I'm afraid. Unfortunately while I mess with it, it's not my strong point.

I remember seeing a similar query on here not too long ago so you may want to use the search facility and see what you come up with.

Sorry can't be more help.