Return the next row value based on criteria

Hello Dears,

I need to look for a value within a range and get the next row value if found with specific formating, attached is an example for what expected.