LinkBack URL
About LinkBacks
Dear all expert,
I have large spread sheet in which multiple cell contain data and the rest are empty, in this scenario i want to highlight all the empty column.I have header all over the column. your help will be required.
Thanks in advance
Dear all expert,
I have large spread sheet in which multiple cell contain data and the rest are empty, in this scenario i want to highlight all the empty column.I have header all over the column. your help will be required.
Thanks in advance
Try Conditional formatting using a formula like this
=A$2:A$13=""
I set CF in one column first then use format painter to copy it across the number of columns
change the 2 and the 13 to set the range for the rows you want included in each column
Happy with my advice? Click on the * reputation button below
Bro it wont work on the column which contain text. please help
As far as I understood you didn't want formatting on columns that contained any text. So you should only see the formatting you applied in columns where they are blank. Maybe best to post a copy of your workbook showing how you want it to lookOriginally Posted by adeelShah
Hi Adeel,
You may consider posting a sample of your workbook with expected output (manually), you will get more quicker and targeted response.
I guess, you can use the simple CF formula;
supposed your data starts with A2, select your range, and apply the following CF formula:
=LEN(A2)=0
This will highlight the cells which are empty, or having formula resulted "" null strings.
If you want to highlight the entire range (supposed A2:A11), first select the range and try the following:
=COUNTIF(A$2:A$11,"")>0
This will highlight the entire column range if there are 1 or more blank(s).
Blessing
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks