I am putting together a spreadsheet and I am pretty handy with Excel but ran into a problem and I would greatly appreciate any help.
What I am trying to do is use an if formula, for example =IF(c3=d3,A,F), but instead of having the output if the value is true be A and the output if the value is false be F, I would like the value to be a solid green box if true and a solid red box if false......
Anyone know how to do this?!?
Thank you.
Bookmarks