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