Format only cells that sum of values is higher than comparing value

[Jan Zitniak]

Hi folks.

Can you give me some idea please how to use conditional format if I need format only those cells that meet following rule:

Format only cells that sum of values is higher than comparing value. Please look at following picture. I need conditional formatting for cells in C10:F10. In cells C10:E10 is green color because SUM(C10:E10) is lower than K1. Cell F10 is red because SUM(C10:F10) is higher than K1. Also others cells to right are red.

Picture
cell-formatting-by-sum.png

Thank you in advance if you help me how to resolve this problem.
Regards Jan

[Pete_UK]

Along with many other contributors, I am not able to view .png files on this forum due to software incompatibilities with some browsers - attach an Excel workbook instead, then more people will be able to make sense of what you are trying to do.

Pete

[bebo021999]

Select range C10:F10 then apply following formula in CF:

=SUM($C$10:C$10)>=$K$1

[Jan Zitniak]

Thanks Pete_UK for your quick response. I already update my question with attachment.

[Phuocam]

Formula for CF range C10:H10

=SUM($C$10:C$10)>=$K$1 -> red

=SUM($C$10:C$10)<$K$1 -> green

[Jan Zitniak]

Thank you bebo021999, your solution works very well