Formula that adds colors to a cells range sum, based on a specific cell.

[Mondergate]

Hi,

Need a formula that based on a cell value, add color to an adjacent range sum, one color when the sum of range is ≤ the cell value, and a different one when cell value is > the cell value.
eg. Attached.

Thanks.

[63falcondude]

Hello, welcome to the forum!

This can be accomplished through Conditional Formatting. Try this:

Highlight C4:F4 > Conditional Formatting > New Rule > Use a formula
=SUM($C4:C4)<=$B4
Format: Fill green > OK > OK

Highlight C4:F4 > Conditional Formatting > New Rule > Use a formula
=SUM($C4:C4)>$B4
Format: Fill red > OK > OK

[Mondergate]

yes, Thank you !

[63falcondude]

You're welcome. Happy to help!

If that solved your question, please mark this thread as SOLVED.