| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Complex Conditional Formating
I am trying to create condtional formating to turn a cell red with a complex
IF/ LOOKUP Function for the rule. The Function works outside of conditional formating but when used with in condtional formating I get no result. What do I need to do indorder for this work? The IF/LOOKUP Formula is: =IF(B5<"M",IF(B8LOOKUP(B7,Data!F3:F38,Data!E3:E38 )" " The quatation marks have nothing in them because I would like no result just the number already entered in cell "B8". -- Ben A |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Complex Conditional | Excel Worksheet Functions | |||
| Complex conditional formatting | Excel Worksheet Functions | |||
| Complex or Conditional Countif(s) | Excel Worksheet Functions | |||
| Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
| complex?? Q about Conditional formatting | Excel Worksheet Functions | |||
Threaded Mode
