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

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" <(E-Mail Removed)> wrote in
message news:BAB938E6-1912-4534-9269-(E-Mail Removed)...
> 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

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