Conditional Rule to highlight

**Jiptastic** · 05-01-2013, 12:22 PM

Does anyone know how to set a rule using conditional formatting to highlight a cell. I want to use this logic.

If(Range("A1")<>Range("B1"), Highlight Range("A1"))

**etaf** · 05-01-2013, 12:27 PM

if you put

= A1 <> B1

and apply to A1 or range in column A

**matt.nicolai** · 05-01-2013, 12:32 PM

Select your A:A range, go to the conditional formatting button and select more rules from 'Highlight Cells Rules'. Select 'not equal to' in the second drop down box and enter a relative B1 (not $B$1) in the formula box. Set your formatting and you are done.

**Jiptastic** · 05-01-2013, 12:35 PM

Thanks Matt. I think I'm close, but it highlighted the whole column regardless of whether the cell to the right was the same. Are you sure I should enter B1?

**FDibbins** · 05-01-2013, 02:45 PM

1. highlight the range you want to apply the conditional formatting to (all the cells you need to apply it to in A)
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =A1<>B1 format fill red this assumes that your 1st piece of data is in A1 and B1 - adjust as needed

@ matt - you need to try and avoid using entire columns in CF, it becomes very resource-intense and will slow things down, rather, restrict it to the minimum range needed