Conditional Formatting ?

[wrestleflm]

I have a spreadsheet in '07 where cells A1:A30 contain different string of text. Each subsequent column contains the same type of data, though the text in the individual cells may be different. What I am looking to do is compare the text strings in each cell in a row from B - n. Basically, I want to apply conditional formatting to color a cell where the text value is not equal to text in column A. said another way, fill red where any cell within B2:K2 does not equal A2. Likewise, fill red where any cell within B3:K3 does not equal A3, B4:K4 does not equal A4, etc.

Thanks,

Lee

 

[T. Valko]

I have a spreadsheet in '07 where cells A1:A30 contain different string of text. Each subsequent column contains the same type of data, though the text in the individual cells may be different. What I am looking to do is compare the text strings in each cell in a row from B - n. Basically, I want to apply conditional formatting to color a cell where the text value is not equal to text in column A. said another way, fill red where any cell within B2:K2 does not equal A2. Likewise, fill red where any cell within B3:K3 does not equal A3, B4:K4 does not equal A4, etc.

Thanks,

Lee

Will there be any empty cells?

How should empty cells be treated?

 

[wrestleflm]

Yes, there will be blank cells in both column A and columns B-K.

Basically, It's a spreadsheet of all the custom fields in an MSProject file that is used as the mandatory field structure. These are in column A. In some cases, not all the fields are used. Each subsequent column signifies a unique MS Project file and it's file structure. I'm trying to show where they are different from what is mandatory.

 

[wrestleflm]

Sorry...I didn't answer your question. If a cell in column A is blank, it is ok for cells in the same row in columns B:K to be blank or filled in...essentially ignore those. However, if a cell in column A is not blank and a cell in the same row in column B:K is blank, that should be flagged the same as, cells that are not blank, but are different from text string in A.

Hope that makes sense...

 

[T. Valko]

Sorry...I didn't answer your question. If a cell in column A is blank, it is ok for cells in the same row in columns B:K to be blank or filled in...essentially ignore those. However, if a cell in column A is not blank and a cell in the same row in column B:K is blank, that should be flagged the same as, cells that are not blank, but are different from text string in A.

Hope that makes sense...

Try this...

Let's assume the full range to be formatted is B2:K10.

Select the *entire* range B2:K10 starting from cell B2.
Cell B2 will be the active cell. The active cell is the
one cell in the selected range that is not shaded. The
formula will be relative to the active cell.

• Goto the Home tab>Styles>Conditional Formatting>Manage rules>New rule
• Use a formula to determine which cells to format
• Enter this formula in the box below:

=AND($A2<>"",B2<>$A2)

• Click the Format button
• Select the desired style(s)
• OK out

 

[wrestleflm]

Biff. You are the man! Thank You. Works Perfectly. Much appreciated.

 

[T. Valko]

Biff. You are the man! Thank You. Works Perfectly. Much appreciated.

You're welcome. Thanks for the feedback!