I have followed the tutorials online for conditional formatting of banded rows with the =MOD function. It was a success, and now all even-numbered rows have a background fill. However, the whole column is banded now, and I would only like the formatting to apply when there are values inside those rows. I would like the formatting to continue when I put more values, but I do not want the whole column to be formatted ad infinitum even where there's nothing there. Thank you.
Aucun commentaire:
Enregistrer un commentaire