I'm trying to use conditional formatting for a cell where the cell will turn green if the value of the cell =
and the cell will turn red if the value of the cell is not equal to the formula above.=VLOOKUP(B5,'[Corp Ovhd 6.08_Final.xls]summary'!$F$4:$I$150,4,FALSE)
Unfortunately, I don't think you can use conditional formatting when linking to a cell in another file.
Does anyone have any ideas for a way around this?
Thanks,
Mike
Bookmarks