Supposing you need to use the formula in F7: F100,select that range. In the Home ribbon select CF, -New Rule -use a formula...-enter =$F7<>"" and set your formatting accordingly. ( red font and fill yellow) -Ok - Apply

I also noticed you are working with some weird merging of cells. Best to get rid of that

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post