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!