Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting based on active Named Range; IF Function to VBA
Hey,
I have more than 3 conditional formatting and I have more than 3 IF statements in the function - I have 4. The function for four IF statements in my case is listed below. How would I write this as a VBA function? I have numbers in column A, I have to identify, based off 4 active named ranges, who the numbers belong to. For example, if the number in A3 is 9004, the function/code would lookup up and find 9004 under the active named range called SEA_ID and then would put in the B3 column SEA. Any ideas are welcomed, thank you. Bull =IF(COUNTIF(SEA_ID,A3),"SEA",IF(COUNTIF(SPO_ID,A3) ,"SPO",IF(COUNTIF(BUT_ID,A3),"BUT",IF(COUNTIF(ANC_ ID,A3,"ANC","")))) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting based on active Named Range; IF Functionto VBA
On Dec 1, 1:28*pm, Todd wrote:
Hey, I have more than 3 conditional formatting and I have more than 3 IF statements in the function - I have 4. *The function for four IF statements in my case is listed below. *How would I write this as a VBA function? I have numbers in column A, I have to identify, based off 4 active named ranges, who the numbers belong to. *For example, if the number in A3 is 9004, the function/code would lookup up and find 9004 under the active named range called SEA_ID and then would put in the B3 column SEA. Any ideas are welcomed, thank you. Bull =IF(COUNTIF(SEA_ID,A3),"SEA",IF(COUNTIF(SPO_ID,A3) ,"SPO",IF(COUNTIF(BUT_ID, A3),"BUT",IF(COUNTIF(ANC_ID,A3,"ANC","")))) suggest using select case. Look in vba help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting when text is contained in a named range | Excel Discussion (Misc queries) | |||
Conditional formatting 'Named Range' dilemma | Excel Worksheet Functions | |||
Conditional Formatting - 2 Worksheets one Named Range | Excel Worksheet Functions | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
Conditional formatting if value in cell is found in a named range | Excel Worksheet Functions |