Formatting Data in cell in colour
 

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.

Formatting Data in cell in colour
 

format/conditional formatting

" wrote:

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.

Formatting Data in cell in colour
 

Not if you keep the value a formula.

Formulas and real numbers don't support this character by character formatting.

wrote:

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.

--

Dave Peterson

Formatting Data in cell in colour
 

Thanks for your help on this. Unfortunately the Conditional
Formatting won't do what I need here as it'll only do the whole cell
in colour, but thanks for your help.

Cheers, Al.

On 28 Jan, 14:26, dlw wrote:
format/conditional formatting



" wrote:
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.- Hide quoted text -

- Show quoted text -