Help please!!! Conditional Formatting

S

Snwprincess8

I am trying to use either VBA or conditional formatting to find an
highlight rows that fit 2 conditions that both need to be true to colo
it. How would I go about doing it?? Any suggestions would b
great!!!
 
E

Earl Kiosterud

Princess,

General form:

Formula is:
=AND(Condition1, Condition 2)
=AND(A2=1, B2>0)
=AND($A$2=1, $B$2>0)

If you've selected more than one cell, this formula is copied into the other
conditional formatting formulas, and any cell reference will change in the
usual way, unless made absolute ($). If you give a specific example, we can
give a more specific answer.
 
S

Snwprincess8

I want to be able to highlight a row in an array but have it highligh
it only if it matches one condition then another. The array I have i
5 columns 50some rows but 3 sheets like that. 2 columns I don't car
to search by, but would still like it to be highlighted if it is in th
row that does match my search criteria. The other ones are gas flo
and calibration gas. I want to be able to put in a calibration gas
have it find all of the rows that match that then have it filter it b
flow rate. Either I want that row to be highlighted or I would eve
work with it making a new list, but I would want it on the same shee
as where I put in my criteria. Now that I have completely confuse
you.... here is an example..
a b c d e
1 heat H2 XYZ 500 1
2 cool H2 XYZ 200 2
3 mid N2 XYZ 500 3

then I want to enter into a cell H2 then in another cell put 500 an
have it highlight only row 1

Hope that helps! Thanks for any suggestions
 
D

Domenic

Hi,

Using your example and conditional formatting, try,

"Formula Is" =AND($B1=$B$7,$D1=$B$8)

Assuming Cell B7 houses your first criteria

and

Cell B8 houses your second criteria.

Hope this helps!
 
Top