conditional format

[aw]

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.

 

[RobN]

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