Hey community,
I have database in sheet2 which column A contains month names from january to december. and column b,c,d,e contains number of products sold in that month.
i use datavalidation list ( months ) in sheet1 when you choose month from list, result of that month appears. ( index,match )
How can i use conditional formatting? ( if possible arrows green / red ) to show green arrow if product in february sold more than in january? if not red arrow?
I have database in sheet2 which column A contains month names from january to december. and column b,c,d,e contains number of products sold in that month.
i use datavalidation list ( months ) in sheet1 when you choose month from list, result of that month appears. ( index,match )
How can i use conditional formatting? ( if possible arrows green / red ) to show green arrow if product in february sold more than in january? if not red arrow?
Last edited:
