Good Morning
I have a spread sheet where i would like a range of cells highlighted if a certain cell contains text (using conditional formatting).
So if cell A6 contains text then A6:P6 will automatically have a border put around it. I have found a formula to do this:
=COUNTA($A$6)>0
However i would like this formula to do the same for multiple rows, e.g. cells A6:A8 all contain text then borders will be placed around each cell between A6:P8, but cell A9 does not contain text, so I do not want A9:P9 to be bordered.
At the moment I can insert the formula for each row, however there are hundreds of rows and this will take a long time to do this.
Is there a simpler way to do this?
Bookmarks