Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
custom format or conditional format? | Excel Discussion (Misc queries) | |||
How to create a conditional format that changes the number format | Excel Discussion (Misc queries) | |||
Conditional Format - Format Transfer To Chart | Excel Discussion (Misc queries) | |||
copy conditional format to regular format | Setting up and Configuration of Excel | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |