Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Format
Is it possible to set the conditional format of a cell where it will go look
to a range of cells (B2:M150) in another (open) workbook called Employee List (on worksheet Employees) for the value of the current cell and then set the format based on the value which in column M. I guess this would be similar to a Vlookup. So if it found the value in cell B94 (which is a persons name) it would set the conditional format based on the value of cell M94 (which in this case would be PTO, but could be any number of things depending on the name in column B) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Format
Somewhere way off to the right, you will have to insert a reference to that
other workbook. Sounds like you want the info from Cols B and M of the other workbook. In say GB, insert =[OtherWorkbookName]Sheet1!B94, and in GC insert =[OtherWorkbookName]Sheet1!M94 Where you want to conditionally format, use formula is and refer to these two cells. Conditional formatting does not work when referencing another workbook -- Hth Kassie Kasselman "Patrick Simonds" wrote: Is it possible to set the conditional format of a cell where it will go look to a range of cells (B2:M150) in another (open) workbook called Employee List (on worksheet Employees) for the value of the current cell and then set the format based on the value which in column M. I guess this would be similar to a Vlookup. So if it found the value in cell B94 (which is a persons name) it would set the conditional format based on the value of cell M94 (which in this case would be PTO, but could be any number of things depending on the name in column B) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Capture conditional format as cell format | Excel Discussion (Misc queries) | |||
New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
Multiple conditional on conditional format formula | Excel Programming | |||
Multiple conditional on conditional format formula | Excel Programming | |||
Keep format after paste from other worksheets - conditional format or EnableControl solution doesn't work | Excel Programming |