| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting - with 2 conditions
Hi,
I think this is what you want: 1 Select cell C1 and choose Format, Conditional Formatting, 2. From the first drop down choose Formula is 3. Enter the following formula in the next spot =AND(B1<"",C1="") 4. Click the Format button and pick Yellow on the Patterns tab, click OK twice. If this helps, click the Yes button. -- Thanks, Shane Devenshire "Forum freak (at work)" wrote: Hi Can this be done? Kenny W XP pro Office 2003 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PLEASE HELP: More then 3 conditions on Conditional Formatting | Excel Discussion (Misc queries) | |||
| Conditional formatting should allow more than three conditions. | Excel Discussion (Misc queries) | |||
| conditional formatting with four conditions | Excel Worksheet Functions | |||
| Conditional formatting with more than 3 conditions. | Excel Worksheet Functions | |||
| more than 3 conditions in conditional formatting - possible? | Excel Discussion (Misc queries) | |||
Threaded Mode
