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.
Bookmarks