# Conditional Format Question

#### jtalbour

##### New Member
Conditional Format Question

From the example below I would like Cell C2 to highlight

when data in A2 is greater than 0 and the word DISC is in C2
Book1
ABCD
1OnHandBilling
28DISC
30DISC
420ACTI
Sheet3

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.
Select the "Formula Is" option in conditional formatting, and enter the formula:

=AND(A2>0,B2="DISC")

(I am assuming you meant to say "DISC" in B2, not C2).

THank you for the help

How many conditions can be included in the AND statement?
In a conditional Formula

THank you for the help

How many conditions can be included in the AND statement?
In a conditional Formula

I think it's 30, although I could be wrong. In CF you could simply use,

=(A2 > 0)*(B2="Disc")

Replies
1
Views
336
Replies
3
Views
1K
Replies
6
Views
255
Replies
1
Views
250
Replies
14
Views
1K

1,211,710
Messages
6,103,449
Members
447,865
Latest member
Devsito

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back