conditional format

  • Thread starter Thread starter aw
  • Start date Start date
A

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.
 
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
 
Back
Top