Conditional Format 2 queries

[hcabs99]

Hi

I need to build a conditional format which will throw the cell red if:

B1 = GB08 or GB05 AND the current cell is blank

Any ideas folks?

 

[mancemonster]

Hi there,

In conditional formation select Formula is...

=AND(OR($B$1="GB05",$B$1="GB08"),$E$12="")

Format Pattern Red.

This should do the trick!

 

[hcabs99]

Hi there,

In conditional formation select Formula is...

=AND(OR($B$1="GB05",$B$1="GB08"),$E$12="")

Format Pattern Red.

This should do the trick!

Hi

Excel doesn't like it!!

=AND(OR($B$1="GB05",$B$1="GB08"),$b$11="")

The formula you typed contains an error

Any idea why? It looks right to me?

 

[mancemonster]

Hi,

I've copied and pasted the formula back into a work book, and it works perfectly.

Are you inserting it directly into cell B11 and creating a circular ref? or are you going to conditional format for cell B11 and pasting it under "Formula Is"?


Regards

Roger

 

[hcabs99]

Hi,

I've copied and pasted the formula back into a work book, and it works perfectly.

Are you inserting it directly into cell B11 and creating a circular ref? or are you going to conditional format for cell B11 and pasting it under "Formula Is"?


Regards

Roger

It's ok, just sussed it. I have been made to change some of my regional settings to ensure the output of this file uploads correctly into the system (a European one). As a result, i have to substitute all commas in formulas with semi colons which is annoying and i keep forgetting about it! I changed it and it worked fine

Cheers for your help