Conditional Formatting Rules

[TMILJVIPM]

Ok I guess my last question was almost impossible for excel to do so how about this:

Cell H10 Has this formula =IF(F10="","",F10-G10)
Now on the conditional formatting I need these 3 rules:

Cell H10's value is less than 80% of F10 then no fill cell
Cell H10's value is equal to or more than 80% of F10 then yellow fill cell
Cell H10's value is more than F10 then red fill cell
and I need this from H10:H256

 

[JoeMo]

Select H10:H256, go to conditional formatting and use these formulas:

=$H10>$F$10 for red fill and
=AND($H10>=0.8*$F$10,$H10<=$F$10) for yellow fill

 

[TMILJVIPM]

Select H10:H256, go to conditional formatting and use these formulas:

=$H10>$F$10 for red fill and
=AND($H10>=0.8*$F$10,$H10<=$F$10) for yellow fill

Nope all cells are yellow without any data in them. then in cell F10 I enter 100 cell H10 stays yellow but all other cells turn red. I need cells to have no fill in the h10:h256 until each indiviual cell reaches 80% of the value of the correspnding cell in row F10:F256 and then of course when they go over turn red. Also just to clarify each H cell will correspond with each F cell. Such as: cell H123 would be affected by data from cell F123.

 

[T. Valko]

Ok I guess my last question was almost impossible for excel to do so how about this:

Cell H10 Has this formula =IF(F10="","",F10-G10)
Now on the conditional formatting I need these 3 rules:

Cell H10's value is less than 80% of F10 then no fill cell
Cell H10's value is equal to or more than 80% of F10 then yellow fill cell
Cell H10's value is more than F10 then red fill cell
and I need this from H10:H256

What version of Excel are you using?

 

[JoeMo]

That's quite different than what your original post asked for.
Try


=$H10>$F10 for red fill and
=AND($H10>=0.8*$F10,$H10<=$F10) for yellow fill.

Be sure to select the entire range H10:H256 before you enter the rules and that the $ signs are as shown here.

 

[TMILJVIPM]

what version of excel are you using?

2007

 

[TMILJVIPM]

That's quite different than what your original post asked for.
Try


=$H10>$F10 for red fill and
=AND($H10>=0.8*$F10,$H10<=$F10) for yellow fill.

Be sure to select the entire range H10:H256 before you enter the rules and that the $ signs are as shown here.

Its doing the same thing that I stated earlier

 

[T. Valko]

2007

Try these...

For:

Cell H10's value is equal to or more than 80% of F10 then yellow fill cell

Use this formula:

=AND(COUNT(F10:H10)=3,H10>=0.8*F10)

For:

Cell H10's value is more than F10 then red fill cell

Use this formula:

=AND(COUNT(F10:H10)=3,H10>F10)

 

[TMILJVIPM]

Try these...

For:


Use this formula:

=AND(COUNT(F10:H10)=3,H10>=0.8*F10)

For:


Use this formula:

=AND(COUNT(F10:H10)=3,H10>F10)

To be honest I've been going at this for almost 24hrs and im not sure if Im the problem explaining the issue because your formulas are working but just backwards for me so im thinking im not doing a good job of explaining. If I posted a link to my sheet with an example of what I need could you take a look at if for me. Thanks for your time.

 

[T. Valko]

To be honest I've been going at this for almost 24hrs and im not sure if Im the problem explaining the issue because your formulas are working but just backwards for me so im thinking im not doing a good job of explaining. If I posted a link to my sheet with an example of what I need could you take a look at if for me. Thanks for your time.

Yeah, I'll take a look.