conditional condition

[allgeef]

I wish to conditionally highlight a row from B to F if the percentage number in cell C13 is greater than the percentage in a cell in C16 thru C31, but less than the following cell in C16 thru C31. What would a conditional formula be to highlight the row? A copy is attached. Thank you for your help.

[Richard Buttrey]

Hi,
Please give a few examples of conditions and values, with reference to specific cells which would trigger this CF.

It's not clear to me what you mean.
For instance do you mean C13 > any cell in C16:C31?
What do you mean by 'the following cell?

Currently I'm interpreting this as C13 must be > C16 and < C31 since unless C13 is > than C31 it will always be less than C31.

[allgeef]

Presently cell C13 is 14.33%, which would highlight row B20 thru F20. If C13 changes to 18.1% then row B24 thru F24 would be highlighted. Hopefully this clarifies the request. Thank you for your consideration.

[Richard Buttrey]

Hi,

Put the following CF in C16,set the appropriate format and then copy it across and down to F31

Please Login or Register  to view this content.

Take care with the absolute refs. The row 16 ref is not absolute.

Regards

[allgeef]

This works perfect. Thanks much for the quick and precise answer.

May I ask one additional related question? I wish to put the monetary result of the highlighted row in cell G6. For example, if row C25 thru F25 were highlighted, I want E25 (Bonus $) to appear in G6. What would the G6 formula be to accomplish this? Regards, Gary

[Richard Buttrey]

Hi,

Please Login or Register  to view this content.

Rgds

[allgeef]

Ideal, thanks again for the assistance. Regards, Gary