Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |