Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colour formatting using command buttons and comparing data. | Excel Discussion (Misc queries) | |||
change tab colour when using conditional formatting in a cell | Excel Worksheet Functions | |||
How do I use conditional formatting to colour rows of data? | Excel Worksheet Functions | |||
Can you apply split colour formatting to the same cell? | Excel Discussion (Misc queries) | |||
How Can I Read Formatting Data (ie Background Colour) | Excel Discussion (Misc queries) |