There is no formula that sees formatting but since you are using conditional formatting you can use the same formula to know what the formatting of the cell is.
I was using conditional format to fill green with any cell that contains "Most recent day:".
There is another cell with "Most recent day:". That cell is a little different as it has some text before "Most recent day" but after "Most recent day" both cells will have the same text.
=INDEX(B2:B7,MATCH("Most recent day:",LEFT(B2:B7,16),0))