Excel - Cell Conditional Formatting

[CSHANKY]

Say I have an Excel Sheet with two columns A & B.

How do I format Cell B based on the TEXT contained in Cell A ? I repeat: Cell B contains Text - not number.

Example:

If Cell A1 contains text "Complete", Cell B1 should be shaded Blue.

I know how to condition-format a cell dependaning on its own content - but when it depends on another cell - I am stumped !!

Need help with this one gurus - I know you will not let me down !

 

[Bowers74]

Instead of using the "Cell is" use the "Formula is" option in the Conditional Formatting window for cell B1 and enter:

=$A$1="Complete"

Then set the formatting and there you go! ;-)



Peace!!

Mike

Didn't get the answers that you wanted? Take a look at FAQ219-2884

 

[Zathras]

Condition 1
Formula is

  =A1="Complete"

and set your format (tab patterns) to your color.

 

[bluedragon2]

formula is: =A1="Complete"



[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[BossInSearch]

=a1="Complete" as the condition will work.

Be careful and use $a$1 in the above expression, if multiple cells need formatting based on A1's value. Use a1 in the expression if each cell's formatting in column B will depend on the corresponding cell in column A...B1 will depend on A1, B2 will depend on A2, etc.

Lastly, the key point, of course, is that you must always use the "formula is" option in the conditional format dialog when the condition is not based on the cell itself.