Conditonal formatting (I have 4 conditions to meet)

  • Thread starter Thread starter gimley
  • Start date Start date
G

gimley

Hi,

I would like to use conditional formatting to highlight certain rows.
The (4) conditions are as follow:

1. Column D >= 20000 and <= 39999

2. Column X > 2

3. Column Y > 2

4. Column EQ > 1

My problem is that I could not combine these formulae together in the
formula box.

I an really new to conditional formatting.. please help!!

Thanks in advance!
 
Try this,

Highlight column D, go to Format/Conditional Format.
Choose 'Cell Value is', 'Between', 20000 'and' 39999. Pick
the format desired.

Highlight Column X and Y, navigate to conditional format
and choose 'Cell Value is', 'Greater than', 2. Pick the
format desired.

Next doe Column Z and 'Cell Value is', 'Equal to', 1. Pick
the formaat desired.

Charlie O'Neill
 
Just use "And" to combine the conditions:

=AND(X1:X5>2,D1:D5>=20000,D1:D5<=39999,Y1:Y5>2,EQ1:EQ5>1)

Then set your format.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Hi,

I would like to use conditional formatting to highlight certain rows.
The (4) conditions are as follow:

1. Column D >= 20000 and <= 39999

2. Column X > 2

3. Column Y > 2

4. Column EQ > 1

My problem is that I could not combine these formulae together in the
formula box.

I an really new to conditional formatting.. please help!!

Thanks in advance!
 
Back
Top