Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to color font(numeral) on selected two digits from a 3digit ce
My excel data contains three digit combination on each cell. To find selected
two digit on a three digit cell data, I need to color font or shade due to my thousands cell datas. Can this be possible? Please provide detailed info. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to color font(numeral) on selected two digits from a 3digit ce
Hi ghinzrey,
Can't understand the question. Can you make it a bit clearer what you want to do including a sample of data etc. -- Regards, OssieMac |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to color font(numeral) on selected two digits from a 3digit ce
Hi,
Suppose your 3 digit number are located in the range C1:M1000, and the 2 digit number you want to mark is in cell A1 then To conditionally format your cell(s): In 2003: 1. Select the cell you want to format 2. Choose Format, Conditional Formatting 3. Choose Formula is from the first drop down 4. In the second box enter the formula: =OR(VALUE(LEFT(C1,2))=$A$1,VALUE(RIGHT(C1,2))=$A$1 ) 5. Click the Format button 6. Choose a color on the Patterns tab (or any available option) 7. Click OK twice. In 2007: 1. Highlight all the cells on the rows you want formatted 2. Choose Home, Conditional Formatting, New Rule 3. Choose Use a formula to determine which cell to format 4. In the Format values where this formula is true enter the following formula: =OR(VALUE(LEFT(C1,2))=$A$1,VALUE(RIGHT(C1,2))=$A$1 ) 5. Click the Format button and choose a format. 6. Click OK twice If this helps, please click the Yes button. Cheers, Shane Devenshire "ghinzrey" wrote: My excel data contains three digit combination on each cell. To find selected two digit on a three digit cell data, I need to color font or shade due to my thousands cell datas. Can this be possible? Please provide detailed info. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to color font(numeral) on selected two digits from a 3digi
Good day, Mr. Shane...
You've got it right and it's working but just on pairs. How about if the numeral are in between, e.g. cell data 374 and want to shade as 3and 4 are in, which I'm looking at. Thanks. "Shane Devenshire" wrote: Hi, Suppose your 3 digit number are located in the range C1:M1000, and the 2 digit number you want to mark is in cell A1 then To conditionally format your cell(s): In 2003: 1. Select the cell you want to format 2. Choose Format, Conditional Formatting 3. Choose Formula is from the first drop down 4. In the second box enter the formula: =OR(VALUE(LEFT(C1,2))=$A$1,VALUE(RIGHT(C1,2))=$A$1 ) 5. Click the Format button 6. Choose a color on the Patterns tab (or any available option) 7. Click OK twice. In 2007: 1. Highlight all the cells on the rows you want formatted 2. Choose Home, Conditional Formatting, New Rule 3. Choose Use a formula to determine which cell to format 4. In the Format values where this formula is true enter the following formula: =OR(VALUE(LEFT(C1,2))=$A$1,VALUE(RIGHT(C1,2))=$A$1 ) 5. Click the Format button and choose a format. 6. Click OK twice If this helps, please click the Yes button. Cheers, Shane Devenshire "ghinzrey" wrote: My excel data contains three digit combination on each cell. To find selected two digit on a three digit cell data, I need to color font or shade due to my thousands cell datas. Can this be possible? Please provide detailed info. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Column Label: Multiple color font on selected word? | Excel Worksheet Functions | |||
Changing Font color based on font type or size | Excel Discussion (Misc queries) | |||
How do I get Roman Numeral Font? | Excel Discussion (Misc queries) | |||
My fill color and font color do not work in Excel Std Edition 2003 | Excel Discussion (Misc queries) | |||
change display font to actual selected font | Excel Discussion (Misc queries) |