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
|