Conditional Formatting Basics

  • Thread starter Thread starter David in VB
  • Start date Start date
D

David in VB

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
 
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.
 
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
 
Back
Top