Hi all,
Wondering if I can pick your brain. Trying to get a conditional formatting formula working and coming up short (the slight differences from actual excel cell formulas are maddening to learn).
In short here's what I need (dumbed down but what I need isn't this basic I promise I just need to see how it's keyed).
If cell A1 = apple then green background, elseif A1 = orange then green background otherwise no background colour
Hoping that makes sense otherwise can attach a spreadsheet
Thanks in advance you guys and gals are awesome!
Bookmarks