conditional formatting once row values hit 50%

[ammartino44]

Hello. Is there a way I can conditional format rows (with 13 cells across columns) so that once it hits a running 50%, it turns blue? The 13 values cells = 100% and each row is a %. So 1st cell is 5.8%, 2nd 3.2% etc.

[mrice]

Use a formula to define the formatting condition

Formula =SUM(A$1:A1) >0.5
Applies to =$A:$A

[ammartino44]

But I just want the 1st value that hits the 50% mark, nothing afterwards.

[mrice]

Assuming that you have a header row, this might work

=AND(SUM(A$2:A2) >=0.5,SUM(A1:A$2) <0.5)

[Tony Valko]

Can you post a SMALL sample file and show us what result you expect?

A SMALL file will have about 20 rows worth of data.

A SMALL file in xlsx format will be about 9kb in size. We don't want files that have 1000's of rows and dozens of columns worth of data! Remember, it's a SAMPLE file!

P.S.

Sorry about the rant!