conditional format
 

Can anyone can help to using condition format to hightlight column D for
cells that meet the following conditions.

1. column A = €œa€� .and.
2. column D <=10

A B C D
1 NAME XX XX AMT
2 A 11
3 B 10
4 B 34
5 A 2
6 C 54
7 A 2

Result should be : cells D5 & D7 being highlighted.

Tx a lot for help.

--
aw

conditional format
 

Select D2 and in conditional format type in the formula section
=AND($A3="A",$D3<=10) then go to format and choose the fill colour.
Copy or format down as required.

Rob

"aw" wrote in message
...
Can anyone can help to using condition format to hightlight column D for
cells that meet the following conditions.

1. column A = "a" .and.
2. column D <=10

A B C D
1 NAME XX XX AMT
2 A 11
3 B 10
4 B 34
5 A 2
6 C 54
7 A 2

Result should be : cells D5 & D7 being highlighted.

Tx a lot for help.

--
aw