Excel 2010 Conditional formula 1

[HPNAGA]

Hi I am not that good with excel so please bare with me ..I am using excel version 2010.
I have data like this
Column A Column B column C
Abc.......abc.....abc
ccc.......ccc.....ccc
bab.......bab.....bab
aaa.......aaa.....aaa
ccc.......aa......ccc
ccc.......cc......cc

and i want to highlight if the NOT (column A = column B = column C) = TRUE and it will be highlighted like below...

Column A Column B column C
Abc.......abc.....abc
ccc.......ccc.....ccc
bab.......bab.....bab
aaa.......aaa.....aaa
[highlight #FCE94F]ccc.......aa......ccc
ccc.......cc......cc[/highlight]

Thanks in Advance.

 

[randy700]

One way would be to set two conditions:
=$A1 <> $B1 format = yellow background
=$A1 <> $C1 format = yellow background

Apply this formula to all cells in the range.


Randy

 

[HPNAGA]

so how do i write the formula and also the data...i mean when i add formatting formula it remeoves data...is there somethingi am missing??

 

[SkipVought]

[tt]
=NOT(AND($A2=$B2,$A2=$C2))
[/tt]


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[SkipVought]

You have to do this in Home > Styles > Conditional Formatting .. NEW RULE >> Use a formula to determine which cells to format

You must first have ALL the cells selected that you want the formatting applied to and then your formula MUST refer to references in the FIRST ROW OF YOUR SELECTION. My selection was A2:C7. Hence my formula refers to the FIRST ROW IN THAT RANGE.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[HPNAGA]

I have selected A1 to C3 and the data was as follows

ccc cc cc
abc aaa aa
aaa aaa aaa

and then clicked on conditional Formatting and then new rule and then Use a formula to determine which cells to format
and then pasted the formula =NOT(AND($A2=$B2,$A2=$C2)) and i have got only the first row highlighted in yellow where i was looking for the second row also to be highlighted...what am i overlooking?

 

[SkipVought]

I have selected A[red]1[/red] to C3 and the data was as follows.... =NOT(AND($A2=$B2,$A2=$C2))

your formula MUST refer to references in the FIRST ROW OF YOUR SELECTION

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]