A Font Macro

[CARBOB]

I use the following spreadsheet to keep track of lottery drawings, which I input every morning. My question is this. Is there a way to have the number,if it is a double digit number to automatic change the font to a different color than black? The numbers in red are double digit numbers.Is it possible? I think, I need a macro because the spreadsheet is quite large.Thanks

Carbob

MY FIRST MACRO.xls
	A	B	C	D	E	F	G
7	11/17/05	464	208	786	286	519	002
8	11/16/05	649	904	590	377	959	929
9	11/15/05	657	307	688	184	696	658
10	11/14/05	193	718	958	405	995	928
Sheet3

 

[Oaktree]

Format all of the cells with black colored font. Then, conditionally format (format --> conditionally format) B7 with formula is: =OR(LEFT(B7)=MID(B7,2,1),MID(B7,2,1)=RIGHT(B7),LEFT(B7)=RIGHT(B7)), click on the format button within the conditional format declaration, and set the font color to red. Copy and paste (edit --> paste special --> formats) the format from B7 to the other cells.

 

[CARBOB]

Fantastic Oaktree, thank you very much.

Carbob