Conditional Formatting

[stephenclarke111111111]

Hi,

I'm trying to highlight cells that = "0" in a row but only up to a total of what's in column "E" and leave anything in the same Row after the total is achieved.

Example below, top half is what I have, then below is the result I'm after.

So, the top row only has the first 3 cells highlighted as the total is 3 and leaves the remaining cell that equals "0"

Then the row below is 5 free and I have 5 cells the equal "0" so all get highlighted.

Look forward to any help.

Thanks.

 

[Fluff]

How about

=AND(F4=0,COUNTIFS($F4:F4,0)<=$E4)

 

[stephenclarke111111111]

=AND(F4=0,COUNTIFS($F4:F4,0)<=$E4)

I can't get that to work sorry, it's basically just highlight cells that ="0" from left to right on that row until it reaches the count of the number in column E , thanks.

 

[Fluff]

I can't get that to work

In what way?

 

[stephenclarke111111111]

It only applies to one cell

 

[Fluff]

Did you select the whole range it needs to work on before applying the rule?

 

[stephenclarke111111111]

I did but only highlighted Leicester or nothing, probably just me sorry.

This is what I'm trying to achieve,

Regards.

 

[Fluff]

What is the applies to range?

 

[stephenclarke111111111]

So, outcome I'm after,

B12:I12 highlights in yellow up to the total of cell A12....... A12 has 6 so 6 "0"s highlight up to the total from left to right.

Example on row (15), H15 isn't highlighted as A15 = 4 and you have 4 "0"s before you get to H15,

 

[Fluff]

That is exactly what the formula I supplied does.

Fluff.xlsm
	E	F	G	H	I	J	K	L	M	N
1
2
3
4	3	4	0	6	0	4	0	2	2	0
5	5	0	1	1	0	5	0	2	0	0
Data

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
F4:N5	Expression	=AND(F4=0,COUNTIFS($F4:F4,0)<=$E4)	text	NO

Can you please answer my question.