hi giys
i want to drag conditional formatting with cell reference. if i use formatt painter, its use same cell reference in all cells
in attached file. i want to use formula in conditional formatting that
if AQ3 => 50% than highlight AD3 as green and if below 50% than red and if i drag the condtional somehow or use painter than it should move with cells such as
AQ4 => 50% than highlight AD4 as green and if below 50% than red
AR3 => 50% than highlight AE3 as green and if below 50% than red & so on to all table
i want to drag conditional formatting with cell reference. if i use formatt painter, its use same cell reference in all cells
in attached file. i want to use formula in conditional formatting that
if AQ3 => 50% than highlight AD3 as green and if below 50% than red and if i drag the condtional somehow or use painter than it should move with cells such as
AQ4 => 50% than highlight AD4 as green and if below 50% than red
AR3 => 50% than highlight AE3 as green and if below 50% than red & so on to all table