A Font Macro

CARBOB

Well-known Member
Joined
Jun 6, 2005
Messages
1,860
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
ABCDEFG
711/17/05464208786286519002
811/16/05649904590377959929
911/15/05657307688184696658
1011/14/05193718958405995928
Sheet3
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,988
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,452
Messages
5,572,209
Members
412,448
Latest member
ManuW
Top