How to highlight cells referenced by other cells

[Guest]

I am working on a weld log and would like to highlight a cell in the
corresponding row when I enter certian information in another cell. Basically
when I enter a weld metal being identified as Stainless Steel in one column I
want another column to automatically be highlighted to let myself know that
certian things are required of that weld. I am not all that skilled with
Macros and conditional formatting doesn't seem to let me do any highlighting.

 

[Guest]

Here is how to make conditional formats work for you:

1. say your row of data is row #10
2. say your lookup value is entered into cell A10
3. format cell A10 conditional with formula is:
=A10=$A$1 and set a distinctive background color
4. copy this formula across the row
5. if any cell in row 10 matches the value in A10, then that cell will be
hi-lighted.