I have an annual report spreadsheet comprised of 15 rows (1 - 15) and 5
columns (A - E). In columns "B" and "D" I add numbers from the current
year, leaving future year cells blank. I highlight in yellow the blank
future cells in columns "B" and "D" by a conditional format "formula is =
ISBLANK(B9)". I leave past year cells in "B" and "D" with numbers but no
highlight colors. I wish to highlight in green the current year numbers in
columns "B" and "D", which will always be a cell above the first yellow
blank cell, and a cell below last years non-highlighted numbered cell. Each
year as I add new annual numbers to column "B" and "D", the previous green
cells would change from green to no highlight and the previous yellow blank
cell would change to a green highlight.

What would condition #2 be in the conditional format formula?

Thank you for your time and help.

Regards,
Gary