Conditional Formatting

I want to create a set of conditional formatting rules where if cells H1 to K1 add up to a certain sum, then highlight cell A1 a certain way, otherwise do nothing. Then if H2 to K2 add up to a certa...

Charts & Visualizing Data

Tutorial

Haytham Amairah
Dec 31, 2017
Kevin,

Do the following steps

Select cell A1.

Go to Home >> Conditional Formatting >> New Rule.

From the New Formatting Rule dialog box select the rule type of (Use a formula to determine which cells to format).

In the formula box type this formula for example:

=SUM(H1, K1)>=70

Finally, click Format button to determine the format that you want, then hit OK.

You can do the same thing for as many cells as you want.

Haytham Amairah

Silver Contributor

Dec 31, 2017

Kevin,

Do the following steps

Select cell A1.
Go to Home >> Conditional Formatting >> New Rule.
From the New Formatting Rule dialog box select the rule type of (Use a formula to determine which cells to format).
In the formula box type this formula for example:
```
=SUM(H1, K1)>=70
```
Finally, click Format button to determine the format that you want, then hit OK.

You can do the same thing for as many cells as you want.

Kevin Burel

Copper Contributor

Dec 31, 2017

Thank you! That's exactly what I needed - just had no idea where to start. I appreciate you taking the time to help me!!

Forum Discussion

Conditional Formatting