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
--
Thanks and kind regards


"RaymundCG" wrote:

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

--
Thanks and kind regards


"Ed" wrote:

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