Conditional Formatting Based On Contents Of A FOREIGN Cell (URGENT!)

[BrooksTech]

I have Excel 2003 (Office XP SP3) It seems to only let me Conditionally Format the Instant-Cell based on its Self-Same Contents. It also gives me the option of entering a Formula, but WHAT kind of formula would I use? Are there any Formulas I can use to get around this restriction?

To further clarify, Id like to say something like "IF (A3="Y") Format {this cell (B3)} RED)

If you know the correct formula please post it asap (needed by 5/10/11)

 

[T. Valko]

I have Excel 2003 (Office XP SP3) It seems to only let me Conditionally Format the Instant-Cell based on its Self-Same Contents. It also gives me the option of entering a Formula, but WHAT kind of formula would I use? Are there any Formulas I can use to get around this restriction?

To further clarify, Id like to say something like "IF (A3="Y") Format {this cell (B3)} RED)

If you know the correct formula please post it asap (needed by 5/10/11)

Try this...

• Select cell B3
• Goto the menu Format>Conditional Formatting
• Select the Formula Is option
• Enter this formula in the box on the right:
• =A3="Y"
• Click the Format button
• Select the desired style(s)
• OK out

 

[BrooksTech]

CF Based On Contents Of A FOREIGN Cell

Thanks, it worked! Actually, that was only the beginning. I wanted the entire row RED if the contents of ANY THREE CELLS was undesireable, using the "ADD>>" as follows:

Formula_Is Condition1: =$A2="N" {Format}
Formula_Is Condition2: =OR($B2="N") {Format}
Formula_Is Condition3: =OR($C2="Y") {Format}

>>Final question out of curiosity, does the later versions of Excel permit more than 3 Conditions? Could there have been a way to do this using only ONE Condition Feature?

Thanks again.

 

[T. Valko]

Re: CF Based On Contents Of A FOREIGN Cell

Thanks, it worked! Actually, that was only the beginning. I wanted the entire row RED if the contents of ANY THREE CELLS was undesireable, using the "ADD>>" as follows:

Formula_Is Condition1: =$A2="N" {Format}
Formula_Is Condition2: =OR($B2="N") {Format}
Formula_Is Condition3: =OR($C2="Y") {Format}

>>Final question out of curiosity, does the later versions of Excel permit more than 3 Conditions? Could there have been a way to do this using only ONE Condition Feature?

Thanks again.

It's not real clear what you want to do.

Here's my best guess...

Let's assume you want to highlight the range A2:C2 if A2 = N or B2 = N or C2 = Y.

• Select the entire range A2:C2
• Conditional Formatting
• Formula is: =OR($A2="N",$B2="N",$C2="Y")

In Excel 2007 and later there is no set limit as to the number of conditions. You're only limited by system resources like memory.

 

[BrooksTech]

CF on multiple FOREIGN Cells

Thanks Biff! I tried a close variation of that earlier but must have had the syntax wrong. I'll save your suggestion in my future archives.

BTW, are you the Biff from "Back To The Future?" heh-heh (If so, I guess you would be keeping all Future Sports Statistics in your Spreadsheets!) LOL! Sorry Biff, I just couldnt resist!

 

[T. Valko]

Re: CF on multiple FOREIGN Cells

Thanks Biff! I tried a close variation of that earlier but must have had the syntax wrong. I'll save your suggestion in my future archives.

BTW, are you the Biff from "Back To The Future?" heh-heh (If so, I guess you would be keeping all Future Sports Statistics in your Spreadsheets!) LOL! Sorry Biff, I just couldnt resist!

Good deal. Thanks for the feedback!