| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Format (exclude 0)
Excel2003 ... Range A6:G6 contains Formula's
Cell A6 contains a Name (returned by formula) Range B6:G6 contains values 0 to 7 (returned by formula & may repeat) I wish to set conditional formatting in Cell A6 Condition = when value in Range B6:G6 is =1 & <5. Thanks ... Kha |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Format (exclude 0)
Hi,
What do you want to happen when your condition has met????? Thanks, -- Farhad Hodjat "Ken" wrote: Excel2003 ... Range A6:G6 contains Formula's Cell A6 contains a Name (returned by formula) Range B6:G6 contains values 0 to 7 (returned by formula & may repeat) I wish to set conditional formatting in Cell A6 Condition = when value in Range B6:G6 is =1 & <5. Thanks ... Kha |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting to Exclude Weekends | Excel Worksheet Functions | |||
| Conditional formatting to exclude weekend and Bank Holidays | Excel Worksheet Functions | |||
| Conditional Formatting to exclude weekends and Bank Holidays | Excel Worksheet Functions | |||
| Conditional formatting to exclude weekend and Bank Holidays | Excel Worksheet Functions | |||
| How to exclude conditional calculated no or zero values from a cha | Charts and Charting in Excel | |||
Hybrid Mode
