Conditional formatting of Excel 2010

[jdctaylor]

I am trying to come up with a conditional formatting formula that will auto fill in a cell based on the percentage value compared with the value in another cell.

In the example below, I want the cells D3:F3 to change color based on its percentage compared with the value in B3.
Excel capacity.jpg

[FDibbins]

Hi, welcome to the forum

It is always better to upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

having said that, you need to use the "use formula" option.

Start with the <0% (although I don't see how a machine can have < 5% capacity?)
Then work up with <25%, then <50% and finally <100%
If you do it in that order, then the <100 rule will be 1st and the 0% will be the last rule, and you wont need to include > than in the rules.

If you still have a problem, upload a sample WB

[jdctaylor]

I am trying to come up with a conditional format that will automatically fill in a cell based on specific criteria.

In the attached example, I am wanting D3:F3 to look at the percentage value of that cell against B3 and fill in the cell accordingly.

[bebo021999]

See attachment.

[JBeaucaire]

Welcome to the Forum, unfortunately:

The duplicate post did not comply with Rule 5 of our forum rules.

Threads Merged.

[sandy666]

bebo021999, what if capacity = 0? 50% (or whatever % >0) of 0 = 0 so it shouldn't be checked by any colour, I think.


Copy of Conditional format_sandy.xlsx

[bebo021999]

Sandy, I followed how his sample cells are formatted. I supposed his "criteria in words" is "less than or equals 0%" instead of "less than 0%".

[sandy666]

Yeah, but I am talking bout B column (Capacity) not D,E,F.
If any B value will be 0 all in row shouldn't be coloured like I said any% of 0 is 0. This is not truth, 16 is not 50% of 0
You are right with criteria but IMHO, not with math.