| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting with IF function
A B
1 Apple 10 2 Apple 5 3 Orange 14 4 Orange 17 I want to highlight column B in such a way that IF column A1= Apple and value in column B1 in not between 6-9, highlight column B in red; IF A1 = orange and value in column B not between 15-18, highlight in red too. How to do this? Thanks in advance for reply. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting with IF function | Excel Discussion (Misc queries) | |||
| Conditional Formatting with IF function | Excel Worksheet Functions | |||
| Help on a function with Conditional Formatting | Excel Worksheet Functions | |||
| Conditional Formatting (IF function) | Excel Worksheet Functions | |||
| Conditional Formatting "OR" function | Excel Worksheet Functions | |||
Threaded Mode
