Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple conditional formats met
I want to set a conditional format so that the formatting will show only if
BOTH conditions are met. Condition 1: B520 Condition 2: B5C5*1.5 I am using XL 07. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple conditional formats met
Try this for the formula
AND(B520, B5C5*1.5) -- HTH, Barb Reinhardt "mtt" wrote: I want to set a conditional format so that the formatting will show only if BOTH conditions are met. Condition 1: B520 Condition 2: B5C5*1.5 I am using XL 07. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple conditional formats met
Awewsome! It worked. Thanks.
"Barb Reinhardt" wrote: Try this for the formula AND(B520, B5C5*1.5) -- HTH, Barb Reinhardt "mtt" wrote: I want to set a conditional format so that the formatting will show only if BOTH conditions are met. Condition 1: B520 Condition 2: B5C5*1.5 I am using XL 07. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple conditional formats | Excel Discussion (Misc queries) | |||
Conditional formats- paste special formats? | Excel Discussion (Misc queries) | |||
Multiple Conditional formats | Excel Worksheet Functions | |||
Apply multiple Conditional Formats | Excel Worksheet Functions | |||
how do i use multiple conditional formats in one cell? | Excel Discussion (Misc queries) |