kassie
12/19/2006 9:38:00 AM
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)
>
>
>