Hi Patrick,

Quite honestly, can't seem to come up with a way to do this without a macro, but I would go with a macro...

Function MyFormula(Check_Cell As Range)
    MyFormula = Check_Cell.HasFormula
End Function
Then in conditional formatting:

Conditional Formatting
  • Highlight applicable range >> E4:E9
  • Home Tab >> Styles >> Conditional Formatting
  • New Rule >> Use a formula to determine which cells to format
  • Edit the Rule Description: Format values where this formula is true: =Myformula(E4)
  • Format… [Number, Font, Border, Fill]
  • OK >> OK

Note: Or highlight the range that works for you.