M
mralmackay
Hi,
Is it possible to do the following @ all. I have a formula that
returns results from two different places used for review in a
meeting. I want to show where data exists in the second spreadsheet
bring this into the cell formatted in Red.
Below is the formula currently:
=IF(ISERROR(VLOOKUP($B6,Data!OpenRecordsProcure,
13,FALSE)),"",VLOOKUP($B6,Data!OpenRecordsProcure,
13,FALSE)&IF(ISERROR(VLOOKUP($B6,'[ProcureCCB.xls]Output'!$C$6:$L
$100,8,FALSE)),"",CHAR(10)&"Previous Minutes: " &
VLOOKUP($B6,'[ProcureCCB.xls]Output'!$C$6:$L$100,8,FALSE)))
I want any data returned after & including "Previous Minutes" to be
formatted in Red.
Is this possible?
Thanks in advance, Al.
Is it possible to do the following @ all. I have a formula that
returns results from two different places used for review in a
meeting. I want to show where data exists in the second spreadsheet
bring this into the cell formatted in Red.
Below is the formula currently:
=IF(ISERROR(VLOOKUP($B6,Data!OpenRecordsProcure,
13,FALSE)),"",VLOOKUP($B6,Data!OpenRecordsProcure,
13,FALSE)&IF(ISERROR(VLOOKUP($B6,'[ProcureCCB.xls]Output'!$C$6:$L
$100,8,FALSE)),"",CHAR(10)&"Previous Minutes: " &
VLOOKUP($B6,'[ProcureCCB.xls]Output'!$C$6:$L$100,8,FALSE)))
I want any data returned after & including "Previous Minutes" to be
formatted in Red.
Is this possible?
Thanks in advance, Al.