View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RobN[_2_] RobN[_2_] is offline
external usenet poster
 
Posts: 230
Default 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