Not using VBA code how to change text color to different color after rewrite cell? 🙏🙌👍👍

[Lacan]

Hello Guys,

Simple question, not using VBA code how to change text color to different color after rewrite cell in sequence like below?

RESULTS AFTER FORMULA:

1ºST WRITE TEXT => AUTOMATIC COLOR
2ºND WRITE TEXT => COLOR #0000FF (+ BOLD)
3ºRD WRITE TEXT => AUTOMATIC COLOR
(AND SON ON)


Thank you very much to all.

olanz.xlsx
	D	E
2	RESULTS AFTER FORMULA
3
4	1ºST WRITE TEXT =>	AUTOMATIC COLOR
5	2ºND WRITE TEXT =>	COLOR #0000FF (+ BOLD)
6	3ºRD WRITE TEXT =>	AUTOMATIC COLOR
7	(AND SON ON)
Folha1

 

[James006]

Hello,

Without VBA, the only potential solution is to use Conditional Formatting ...

The only question is : Can you precisely define the conditions which do differentiate your sequence ("write text") .... ???