Click on the Row Header in Row 2 which will highlite the complete Row 2

Format, Conditional Formatting.. Select FormulaIs and enter
=AND($A2=3,$F2=0) in the box - Select Color Pattern

And OK OUT...

Click again on the Row Header of Row 2 - Click the format-Painter Icon
and click on Row-Header 3 and drag down to Rowheader 100; that should
get you started.

HTH,

Jim May


"amanda" wrote:

I would like to highlight a row in excel using a macro that would
compare the cell value in one colum to the cell value in another
column in the same row. Specifically, if the cell value in column A
is 3 or greater and the cell value in column F is 0 I want this row to
stand out. Any ideas?