Can someone please help me write the correct conditional format/formula in Excel 2012?
If B1 + C1 >=5, I want cells A1, B1, and C1 to turn green.
If B1 + C1 < 5, then I don't want anything to happen.
I've been playing around with the Conditional Formatting tab for 45 minutes and I can't figure it out.
Any help you can offer would be appreciated.
Thanks in advance.
If B1 + C1 >=5, I want cells A1, B1, and C1 to turn green.
If B1 + C1 < 5, then I don't want anything to happen.
I've been playing around with the Conditional Formatting tab for 45 minutes and I can't figure it out.
Any help you can offer would be appreciated.
Thanks in advance.