Hi,
I added conditional formatting, if A$1<>"" then color the whole A:A column, I applied this to the whole sheet but it colors all columns only based on cell value in A1, why is that? I tried all combinations with the $ sign but not working. I want Excel to color the column if the column is not blank in its first cell. Help on this simple matter?
I added conditional formatting, if A$1<>"" then color the whole A:A column, I applied this to the whole sheet but it colors all columns only based on cell value in A1, why is that? I tried all combinations with the $ sign but not working. I want Excel to color the column if the column is not blank in its first cell. Help on this simple matter?