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.

 

[stephenclarke111111111]

 

[Fluff]

The formula needs to look at row 4 not row 1

 

[stephenclarke111111111]

The formula needs to look at row 4 not row 1

 

[Fluff]

Please use the formula I posted rather than changing it.

 

[stephenclarke111111111]

Hi,,

This worked but only if the "0"s are less or equal to E4 number.

E.G... E4 equals 5 and I have 6 "0"s in that row it won't work, I'd be expecting the fisrt 5 "0"s left to right to appear in green.

Below is what i'm using.

Thanks.

 

[Fluff]

That is still not the formula I suggested. It needs to be

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

 

[stephenclarke111111111]

Sorry , all sorted and working thank you.

Don't suppose you know how to count cells with conditional formatting when you do a colour check on the cell in doesn't return a colour code.

 

[Fluff]

That would need either VBA or a formula that replicates the CF rules.

 

[stephenclarke111111111]

Yeah, tried all sorts, but colour or font not recognised as different to work with a countif

I'll create a post, thank you for helping.