Conditional Format--2 conditions need to be true

[CrimsonPlague29]

Hello,

I know how to conditional format an entire line if one condition is met
(using =$A2=TRUE)

I want the conditional format to highlight the line item only if the
following is met
Status= CMP and Product = A
(sample spreadsheet data)
Status Product BuildQTY TOGOQTY
CMP A 10 0
OPN A 20 10
CMP B 15 0
CMP C 5 0
I do not want to highlight any other Products that are status cmp

Thanks
Crimsonplague29

 

[PCLIVE]

Try this:

Highlight the area in which you want the CF to be applied. Then click
Format|Conditional Formatting.

For the Ones (1) in the cell references below, change these to match the
first row that you started to highlight from.

Formula Is
=AND($A1="CMP",$B1="A")

HTH,
Paul

 

[Max]

Select the entire sheet (A1 active),
then apply CF using Formula Is:
=AND($A1="CMP",$B1="A")
Format to taste, OK out