I have Excel 2007 and for some reason I can't get started on Conditional
Formatting. For instance, I just want to highlight any cells that contain
values the appear in other cells. I assumed this was "highlight duplicate
cells" but I can't find where to plug in the range or tell Excel what columns
to search.

I'd like to ask if anyone can tell me how to make the above formatting
happen. Thanks! I really appreciate it.

You can use a formula. If you want to highlight B1 if it contains a value
that appears in C15, use the formula =B1=C15. B1 will have to be exactly
equal to C15. If it is, the formula returns TRUE else FALSE. Then select the
formatting you want.

Tyro

"David in VB" wrote in message
...
I have Excel 2007 and for some reason I can't get started on Conditional
Formatting. For instance, I just want to highlight any cells that contain
values the appear in other cells. I assumed this was "highlight duplicate
cells" but I can't find where to plug in the range or tell Excel what
columns
to search.

I'd like to ask if anyone can tell me how to make the above formatting
happen. Thanks! I really appreciate it.

You'd want to make it:

=B1=$C$15

so that you can copy the format over to any other cell (say in column
B) to compare to that number.


On Feb 4, 12:28 pm, "Tyro" wrote:
You can use a formula. If you want to highlight B1 if it contains a value
that appears in C15, use the formula =B1=C15. B1 will have to be exactly
equal to C15. If it is, the formula returns TRUE else FALSE. Then select the
formatting you want.

Tyro

"David in VB" wrote in ...

I have Excel 2007 and for some reason I can't get started on Conditional
Formatting. For instance, I just want to highlight any cells that contain
values the appear in other cells. I assumed this was "highlight duplicate
cells" but I can't find where to plug in the range or tell Excel what
columns
to search.

I'd like to ask if anyone can tell me how to make the above formatting
happen. Thanks! I really appreciate it.

I would be very careful about copying conditional formatting in Excel 2007.
The conditional formatting does not replace conditional formatting in the
cell to which it is copied, it augments any conditional formatting in that
cell and becomes first in the rules list.

Tyro

"iliace" wrote in message
...


You'd want to make it:

=B1=$C$15

so that you can copy the format over to any other cell (say in column
B) to compare to that number.


On Feb 4, 12:28 pm, "Tyro" wrote:
You can use a formula. If you want to highlight B1 if it contains a value
that appears in C15, use the formula =B1=C15. B1 will have to be exactly
equal to C15. If it is, the formula returns TRUE else FALSE. Then select
the
formatting you want.

Tyro

"David in VB" wrote in
...

I have Excel 2007 and for some reason I can't get started on Conditional
Formatting. For instance, I just want to highlight any cells that
contain
values the appear in other cells. I assumed this was "highlight
duplicate
cells" but I can't find where to plug in the range or tell Excel what
columns
to search.

I'd like to ask if anyone can tell me how to make the above formatting
happen. Thanks! I really appreciate it.