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
|