Hi Excel experts!
I would like to select a particular cell in the column and apply the format to the whole column using conditional formatting.
I tried it like this: =IF(CELL("contents";ADDRESS(9;COLUMN()))=0)
If true -> apply format to all the cell in the column
thanks!
Bookmarks