• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

conditional formatting dragging with reference

ALAMZEB

Member
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
 

Attachments

  • Heats Maps CHANDOO.xlsx
    41.1 KB · Views: 2
Hope this meet you requirement


cheeers
 

Attachments

  • Heats Maps CHANDOO.xlsx
    40.5 KB · Views: 1
Hi Azumi. it still doenst work

anypercentage between -50% to +50% should be highlighted in red
for example. if percentage in one cell of right table is 25% than it shouldnt highlight

only above 50% and below 50%
 
Hi:

Should this be a simple conditional formatting ?
=AQ3<50%
=AQ3>=50%

Or else am I missing something.

Thanks
 

Attachments

  • Heats Maps CHANDOO.xlsx
    42.5 KB · Views: 2
Hi Nebu

its also highlightin red anything between -50% & 50%

if its below -50% than highlight in red
if ts above 50% than highlight green
if its in between and than do nothing



thanks
 
Hi Nebu

i think i am not using correct words. sorry
below willbe clear

anything above & equal -50% gives red
for example -51%, -52%, -53% -54%.......-80% and so on

anything above & equal +50% gives red
for example +51%, +52%, +53% +54%.......+80% and so on


aything in between do nothing
for example -49%, -48%, -47% ..............+47% +48%, +49%
 
Back
Top