| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format--2 conditions need to be true
Hello,
I know how to conditional format an entire line if one condition is met (using =$A2=TRUE) I want the conditional format to highlight the line item only if the following is met Status= CMP and Product = A (sample spreadsheet data) Status Product BuildQTY TOGOQTY CMP A 10 0 OPN A 20 10 CMP B 15 0 CMP C 5 0 I do not want to highlight any other Products that are status cmp Thanks Crimsonplague29 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional format with 3 conditions | Excel Worksheet Functions | |||
| Formula to recognize if another cell's conditional format is true | Excel Discussion (Misc queries) | |||
| if any of 3 conditions is true, then answer is true | Excel Worksheet Functions | |||
| Conditional Format - 3 conditions | Excel Worksheet Functions | |||
| more conditional format conditions | Excel Worksheet Functions | |||
Threaded Mode
