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))

 

[imback2nite]

Here are the two images. The Conditional Formatting conditions. I would like the formatting to reside in cell G8. As I said in an earlier post, both conditions work, just not together. I'm using Excel 2003 which is a dinosaur but it's what I have to work with.

 

[Peter_SSs]

Thanks for the images. I do have your version to test so what happens if you swap the order of the conditions (with the same data as above)?
Does G8 then get coloured but no border?

 

[imback2nite]

Thanks for the images. I do have your version to test so what happens if you swap the order of the conditions (with the same data as above)?
Does G8 then get coloured but no border?

Yes. If I swap the conditions cell F8 will get coloured with no border. But when is F8 is no longer blank the colour will disappear and the border will appear. Best result will be if there is information in cell B8 there will be a border in cell F8. After that when there is information in cell F8 and G8 is blank, F8 will be coloured. Then when G8 has information the colour in cell G8 will disappear but will still have the border. Am I asking too much?

 

[Peter_SSs]

I'm not quite sure what actual combinations of circumstances you are actually likely to have in those 3 columns (B, F & G) but give this a try.

Condition 1 with the formatting of both border and colour
=AND(NOT(ISBLANK($B8)),ISNUMBER($F8),ISBLANK($G8))

Condition 2 with the formatting of border only
=NOT(ISBLANK($B8))

 

[imback2nite]

I'm not quite sure what actual combinations of circumstances you are actually likely to have in those 3 columns (B, F & G) but give this a try.

Condition 1 with the formatting of both border and colour
=AND(NOT(ISBLANK($B8)),ISNUMBER($F8),ISBLANK($G8))

Condition 2 with the formatting of border only
=NOT(ISBLANK($B8))

That's perfect! I never thought of that! I was trying to add another column but that would have created a whole new set of problems! Thank you!

 

[Peter_SSs]

You're welcome. Thanks for the confirmation.