Conditional Formatting in the same cell

[imback2nite]

Hi and thanks for looking at what I would think would be easy but for some reason I can't understand. I'm trying to use Conditional Formula. This condition will reside in cell G8 and be dragged down to cell G44.
Condition #1 works great. Condition #2 will not. Is this because the Condition will reside in the same cell? Anyway, I appreciate your time.
Condition #1 is

=NOT(ISBLANK($B8))

Condition #2 is

=AND(ISNUMBER($F8),ISBLANK($G8))

 

[StephenCrump]

You haven't said what is happening.

But presumably F8 is numeric, and (you think) G8 is blank, and the cell is not formatting as required.

Is G8 blank, or does it have a formula that returns ""? If so, you'll need to test whether G8="" rather than using ISBLANK

 

[imback2nite]

What's odd is that if I put the Conditional Formatting in cell H8, it works fine. In so saying is that F8 IS numeric and G8 IS Blank. Is there a reason that I'm not able to use cell G8? Circular Reference?

 

[StephenCrump]

Is there a reason that I'm not able to use cell G8? Circular Reference?

No reason you can't put the formula in G8. It won't cause a circular reference.

In simple terms, if G8 is conditionally formatted with the formula: =AND(ISNUMBER($F8),ISBLANK($G8)) then the cell will format if both these conditions are met.

If G8 is not formatting, it means:
ISNUMBER(F8) is FALSE and/or ISBLANK(G8) is FALSE

OR

The conditional format formula in G8 is not what you think it is: =AND(ISNUMBER($F8),ISBLANK($G8)).

If you're applying conditional formatting to multiple cells, it's easy to make a mistake and have the formula pointing not quite where you think it is.

 

[imback2nite]

I guess there's some sort of conflict in Conditions. When I delete Condition #1, Condition #2, now Condition #1 works. Sigh
What's odd is the old condition #1 was to input borders. Condition #2 is to add a pattern.

 

[Fluff]

Do you have "Stop if True" checked for the 1st rule?

 

[imback2nite]

Do you have "Stop if True" checked for the 1st rule?

No. I don't see that. I'm using Excel 2003. Is it there?

 

[Fluff]

I can't remember if it was an option in 2003 or not. It maybe that 2003 cannot handle multiple rules for the same cell.

 

[imback2nite]

I can't remember if it was an option in 2003 or not. It maybe that 2003 cannot handle multiple rules for the same cell.

. I'll look around and see if I can find something. I do appreciate the help!

 

[Peter_SSs]

I can't remember if it was an option in 2003 or not. It maybe that 2003 cannot handle multiple rules for the same cell.

In 2003 there was no 'Stop if True' and cells could have up to 3 conditional formatting rules.

@imback2nite
With some suitable (varied) data in rows 8:12 and your two CF rules in place in G8:G12, can you select G8, go into Conditional Formatting and take a snip of the rules. Along the lines of this pic

Can you also take a snip of the actual sheet covering B8:G12 after hiding columns C, D & E?