Thank you! I am getting closer..For some reason, it is picking up numbers in
column B that are less than 0.25???

On a 2nd note:
Is there a way in say in Column A to pickup number that DOES NOT EQUAL 10
AND in Column B 0.25



"T. Valko" wrote:

You can use conditioning formatting to identify those rows.

Try this:

Let's assume the range of interest is A1:B10.

In Excel 2007

Select the *entire* range of cells, A1:B10, starting from cell A1.
Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a
formula to determine which cells to format
Enter this formula in the box below:
=AND($A1=10,COUNT($B1),$B10.25)
Click the Format button
Select the desired style(s)
OK out

In Excel versions 2003 and earlier

Select the *entire* range of cells, A1:B10, starting from cell A1.
Goto the menu FormatConditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:
=AND($A1=10,COUNT($B1),$B10.25)
Click the Format button
Select the desired style(s)
OK out

--
Biff
Microsoft Excel MVP


"N. Vu" wrote in message
...
How do you highlight rows where it meets 2 criteria.

Highlight the row where
1. Column A equals 10
AND 2. Column B is Greater than 0.25

Do you do some type of lookup/conditioning formatting rule to get it to
find
the rows that meet both criteria.