Conditional Formatting Help

[bflan0524]

need conditional formatting to analyze a full sheet, and fill a cell the color red if the value of that cell is different then what is in column A
what would the formula be

for example
Column A Row 1= ABC Column B Row 1=ABC Column C row 1= BCD i would want C1 to be Red
Column A Row 2=BCD Column B Row 2= BED, Column C Row 2= BCD, i would want B2 to be Red

thanks

 

[KUYJS]

Go to conditional formating
Choose from formula
Enter formula as:
=B1<>$A1

Then choose your colour
Copy B1 and paste format in your table

 

[Fluff]

Select cols B:C & use this formula
=$A1<>B1