title: Conditional formatting based on the result of IF formula in the cell
body: <p>Is there a way we can do conditional formatting based on the result of IF condition present in cell no matter what it returns?</p>
  
  <p>Like if it returns <code>true</code> then color it green if <code>false</code> color it red</p>
  
  <p>The formula looks like this on sheet2 <code>=IF(Sheet3!C35="", Sheet3!B35, Sheet3!C35)</code> it can return any value which is in B or column C that's what makes it hard for me to conditionally format it using hardcoded values or ranges because they are not well defined</p>
  
  <p>I thought of doing it via a macro like this</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
  Application.ScreenUpdating = False
  Application.EnableEvents = False
  
      If Target.Cells.Count = 1 And Target.Cells.HasFormula Then
              'Logic to check the if condition
      End If
  
  Application.ScreenUpdating = True
  Application.EnableEvents = True
  End Sub
  </code></pre>