Conditional Format--2 conditions need to be true
 

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

Conditional Format--2 conditions need to be true
 

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

--

"CrimsonPlague29" wrote in
message ...
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

Conditional Format--2 conditions need to be true
 

Select the entire sheet (A1 active),
then apply CF using Formula Is:
=AND($A1="CMP",$B1="A")
Format to taste, OK out
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"CrimsonPlague29" wrote:
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