how do you have 2 criterias be picked up in a lookup?

[N. Vu]

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.

 

[T. Valko]

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 tab>Styles>Conditional Formatting>Manage rules>New rule>Use a
formula to determine which cells to format
Enter this formula in the box below:
=AND($A1=10,COUNT($B1),$B1>0.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 Format>Conditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:
=AND($A1=10,COUNT($B1),$B1>0.25)
Click the Format button
Select the desired style(s)
OK out

 

[N. Vu]

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]

=AND($A1=10,COUNT($B1),$B1>0.25)
it is picking up numbers in column B that
are less than 0.25???

Hmmm...

I don't think that's possible! Give me some examples of numbers that are
less 0.25 that are being highlighted. You might have the number format set
to display 2 decimal places where the *displayed value* could be 0.25 but
the true underlying value is actually something like: 0.250000231454755.
Excel evaluates formulas based on the true value of a cell. The true value
of that cell is >0.25 so the CF is applied.

If this is what's happening then we'll have to use some rounding.

=AND($A1=10,COUNT($B1),ROUND($B1,2)>0.25)

Is there a way in say in Column A to
pickup number that DOES NOT EQUAL 10

Try this:

=AND(COUNT($A1),$A1<>=10,COUNT($B1),$B1>0.25)

 

[Shane Devenshire]

Hi,

To conditionally format your cell(s):

In 2003:
1. Select the cells you want to format - in your case something like A150
for example.
2. Choose Format, Conditional Formatting
3. Choose Formula is from the first drop down
4. In the second box enter the formula:
=AND($A1=10,$B1>0.25)
5. Click the Format button
6. Choose a color on the Patterns tab (or any available option)
7. Click OK twice.

In 2007:
1. Highlight all the cells on the rows you want formatted
2. Choose Home, Conditional Formatting, New Rule
3. Choose Use a formula to determine which cell to format
4. In the Format values where this formula is true enter the following
formula:
=AND($A1=10,$B1>0.25)
5. Click the Format button and choose a format.
6. Click OK twice

 

[Shane Devenshire]

Hi,

Regarding the second question try

=AND($A1<>10,$B1>0.25)

as the formula