Need a macro that fills cells with color

[Vince777]

As shown in the upper part of the picture.
The macro should fill only cells with text in them and skip the enumerated cells.
Thanks.

[Hrbrgr]

Double?

Count and enumerate blank cells

I need please a formula that counts empty cells and fill them with consecutive numbers before between and after filled cells(AA or any other text ). An example in the picture. [2022-08-30 13_50_01-Untitled 1 - LibreOffice Calc]

[karolus]

@Hrbrgr

Double?

no Double…same source but different Question

[karolus]

Select A8:K10 … then →→Format→→Conditional Format→Condition→→Formula is

istext(A8)

<Cellstyle of your Choice>

[KoJoT]

kein Makro nötig
Zelle: Format :->: Bedingte Formatierung:->: Verwalten :->: Hinzufügen :->: Bedingung 1: Zellwert: ist größer oder gleich: “a” :->: Vorlage verwenden … etc. :->: Zellbereich: A5:Z6 (beispielsweise für 2 Zeilen & 26 Spalten)

[karolus]

@KoJoT

kein Makro nötig

@KoJoT du bist gerade in der englischen Abteilung!