Conditional Formatting

[Guest]

Hello, I have in Column A, 3 possibilities which have "General" format,
either (#), or (#.#) or (#.#.#). I would like to have this as Conditional
Formatting:

1 - (Red, Bold)
1.1 - (Blue, Bold)
1.2 - (Blue, Bold)
1.1.1 - (Black, Normal)
2 - (Red, Bold)
2.1 - (Blue, Bold)
and so on...

How can I manage to put that into the conditional formatting? I tried using
wildcard characters without success...

thanks

 

[Guest]

Try this:

For first condition (bold red), use custom formula:

=LEN($A1)=LEN(SUBSTITUTE($A1,".",""))

For second condition (bold blue), use custom formula:

=LEN($A1)=LEN(SUBSTITUTE($A1,".",""))+1

Third condition could probably be left out as default, but if needed use:

=LEN($A1)=LEN(SUBSTITUTE($A1,".",""))+2

HTH,
Elkar

 

[Guest]

Hi Ed!

Will this help?

Condition 1: Formula is... =ISERR(SEARCH(".",cell_address))=TRUE apply
RED+BOLD
Condition 2: Formula is... =SEARCH(".",cell_address)>=2 apply BLUE+BOLD
Condition 3: Formula is... =SEARCH("*.*.*".CELL_address)=1 apply BLACK+NORMAL

 

[Guest]

re-checked my conditional formulas, they should be actually as follows...

Condition 2: Formula is... =ISERR(SEARCH("*.*.*",cell_address))=TRUE

Condition 3: Formula is... =ISERR(SEARCH("*.*.*",cell_address))=FALSE

 

[Guest]

Thanks Elkar and Raymund!