Conditional Formatting - formula including cells with formulas

Hi,

 

I'm trying to create conditional formatting of cells and need help to confirm the details.

 

 

In my spreadsheet, Columns look like this:

 

Column E                Column F               Column G

Estimates                Actuals                   Subtotal

$15000                    $30000                  $45000

$      -                      $50000                  $50000

 

Although Column G's value is a sum of E & F, the original sum formula is located on a different sheet in the workbook.  In fact, each cell in all 3 columns E, F & G contains a formula to a value from a different sheet in the workbook.  So E5's formula is ='18002'!D17, F5 is ='18002'!E17, G5 is ='18002'!F17. Row 6 refers to a different sheet, and so on.

 

Is the following possible:

I want to create conditional formatting so that if Column E's value displays >0, Column G's font is blue.  (In other words, if the Subtotal still contains an Estimate amount, the font is blue.)

Or

If Column E's value displays 0 (or $     -  , in Accounting), Column G's font is green.  (In other words, if the Subtotal ONLY contains Actuals, the font is green.)

I've colored the example above to match this idea.

 

I'm not sure how to code this because the value in each cell is already a formula, not the actual dollar amount.  I tried Conditional Formatting, Classic style, Use a formula, =COUNTIFS(E5:E83,">0"), but that made everything blue because every cell has a formula so every cell is greater than 0.

 

I am using Excel for Mac 2011 version 14.7.7.

 

Can you please help me?

 

Thanks in advance.