Formatting Data in cell in colour

[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.

 

[dlw]

format/conditional formatting

 

[Dave Peterson]

Not if you keep the value a formula.

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

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.

 

[mralmackay]

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.

format/conditional formatting

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 -