Conditional Formatting icon sets to show progress - Microsoft Community


i have set of numbers shown week week, below. want use single conditional formatting rule display green arrow if weekly figure has increased compared previous, amber arrow if has stayed same , red arrow if has dropped i.e. cell c2 looks cell b2, cell d2 looks cell c2 without me having specify in each cell lookup is. 

i can see how achieve creating new rule each week's figures, there more efficient way? 

hi,

to give basic information condition formatting in excel, suggest check link.

thank you.



Office / Excel / Windows other / Office 2016



Comments

Popular posts from this blog

Getting ErrorCode: 120018 when trying to access Microsoft account - Microsoft Community

The message was sent to a distribution list ‎(DL)‎ - Microsoft Community

Activation Error 0x8004FE93 - Microsoft Community