Complex Conditional Formatting

Hey guys -

I'm looking for a little help with a conditional formatting issue.

Currently, I have cells B20:B90 conditionally formatted to fill yellow when the adjacent cell (column A) contains a value <= cell B2. The formula is (with B20 highlighted) =A20<=$B$2. Simple. At that point, the highlighted cells would be individually filled with values by the user.

Here's the kicker: I want a formula for cell B10 that formats it only once all highlighted cells between B20:B90 contain a value.

Therefore, say every A cell contained its row value and B2 contains 40. Cells B20:B40 would be highlighted based on the formatting above. I want to format B10 to highlight only after the user adds values to (now highlighted) cells B20:B40.

Hopefully I explained this well enough. If need be, I'll upload my workbook for review.

Thanks for the help!

Thanks for the reply, adyteo. That wasn't quite it, but it helped me figure it out!

Please Login or Register  to view this content.

I appreciate the guidance!