User Profile
MegGarcia
Copper Contributor
Joined 4 months ago
User Widgets
Recent Discussions
Conditional formatting using icon sets and relative references
Would appreciate some help, please! Column F contains current scores 1-20 Column G contains previous scores, also 1-20 I need column G to highlight whether the scores have gone up, down or stayed the same. There’s already conditional formatting in column G (red fill for values > 12 , amber fill for 8-12 and green for <8) I tried to use conditional formatting (format all cells based on their values) with icon sets and a formula, but excel doesn’t allow relative references for icon sets and I do need excel to compare cells within the same row, ie G2 with F2, G3 with F3, etc (ideally ignoring blank cells). Is there any other way to do it?309Views0likes2CommentsReturn different values depending on multiple conditions
Hi I wonder if there's someone out there who can help. I've got a set of dates in column C and a set of values 1-12 in column E. I need column L to return dates as follows: For L2: C2+180 if E2 between 1-3 C2+90 if E2 between 4-7 C2+60 if E2 between 8-11 C2+30 if E2 >11 I'm trying to find a formula I can use in column L that will allow all these conditions and return a value accordingly. I'd be using relative references, so L3 would be based on C3 and E3, etc. Any ideas?265Views0likes3Comments
Groups
Recent Blog Articles
No content to show