Lacan
Active Member
- Joined
- Oct 5, 2016
- Messages
- 260
- Office Version
- 365
- Platform
- Windows
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.



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 |