Search results for query: *

How to know the relative locations of cells having following values in column Q. 1) ATP 2) Glucose 3) Protein If these values are not there in that column then I should get msgbox saying that these values are not there in the column'Q'

In my spread sheet the Used columns are from 'A' to 'T'. Out of those columns few columns should not have blank cells. For Eg: A, B, C, D, H, I, K, N coulmns should not have blank cells. If there is any blank cell in those columns for eg in 'A' column then, I should get msg box saying 'There...

Need help in conditional formatting Sector Region Country Telecommunication USA USA Telecommunication USA Canada Transport Africa Kenya Energy USA W.Indies Finance Aus Aus Finance Aus NZ Commerce...

Hi Watson, Again I need help from you. Sector Region Country Telecommunication USA USA Telecommunication USA Canada Transport Africa Kenya Energy USA W.Indies Finance Aus Aus Finance Aus NZ Commerce USA USA Textiles USA Canada Public sector Aus Aus Aviation Europe France Aviation...

Hi watson. I got it. I used following code. Sub Blank_Column() ' ' Blank_Column Macro ' To locate columns with out Data ' Range("A2").Select Selection.FormatConditions.Delete Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _ "=COUNTA(A:A)-1=0&quot...

Hi Watson, It is working . Thank You very much for your help. But I need macro for this function. I try the following code, but I am getting Syntax error. Could you please help me in fixing this. sub Blank_Column() max_columns = 100 'maximum columns that you expect to have in the sheet j =...

I tried. it is working but it is changing the font color of the content in the first row. in my application, as first line is generic line and second line contains header. I wanted to change the color of the font for the content in the secod row. Thank You

I need macro which will automatically change the font color of the heading when there are no records for that column. Thank You