Highlight Cells with different values

[Fuad]

Hi,

I have a column that I want to locate the differences. I can use the
F5---Special---Column Differences. But I wanted to know if I can do it with
Conditional Formatting. Like if Value in A1 is different than the values in
Column A:A, then it is highlighted...

Any help appreciated

Fuad

 

[Rob Giordano \(Crash\)]

Sounds like an Excel question..try one of the Excel newsgroups, this one is
for Publisher.


| Hi,
|
| I have a column that I want to locate the differences. I can use the
| F5---Special---Column Differences. But I wanted to know if I can do it
with
| Conditional Formatting. Like if Value in A1 is different than the values
in
| Column A:A, then it is highlighted...
|
| Any help appreciated
|
| Fuad