Conditional Formatting of cells

[brose99]

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.

 

[shaowu459]

Select a1:c1, enter conditional formatting formula:$b1+$c1>=5
Select a background color you want to fill

 

[brose99]

NAILED IT!

Thank you shaowu459!

 

[shaowu459]

NAILED IT!

Thank you shaowu459!

You are welcome