My output range differs everytime. Formatting this range looks very odd.I
have applied border,fill color to this range.How to apply conditional format
to my variable range output. Sometimes my output range is c2:e30,sometimes
c2:e35,sometimes c2:e17 like that.

Base the formatting on whether or not a cell has data in it.

You'd have to apply it to the largest range that you expect to use. If
c2:e35 is the largest range:

Select the range C2:E35 so that cell C2 is the active cell (C2 is not
"blueish" and all other cells in the range are)

Conditional Formatting
Formula Is: =LEN(C2)

Biff

"TUNGANA KURMA RAJU" wrote in
message ...
My output range differs everytime. Formatting this range looks very odd.I
have applied border,fill color to this range.How to apply conditional
format
to my variable range output. Sometimes my output range is c2:e30,sometimes
c2:e35,sometimes c2:e17 like that.

Thank you Biff,you are great really!

"Biff" wrote:

Base the formatting on whether or not a cell has data in it.

You'd have to apply it to the largest range that you expect to use. If
c2:e35 is the largest range:

Select the range C2:E35 so that cell C2 is the active cell (C2 is not
"blueish" and all other cells in the range are)

Conditional Formatting
Formula Is: =LEN(C2)

Biff

"TUNGANA KURMA RAJU" wrote in
message ...
My output range differs everytime. Formatting this range looks very odd.I
have applied border,fill color to this range.How to apply conditional
format
to my variable range output. Sometimes my output range is c2:e30,sometimes
c2:e35,sometimes c2:e17 like that.

You're welcome!

Biff

"TUNGANA KURMA RAJU" wrote in
message ...
Thank you Biff,you are great really!

"Biff" wrote:

Base the formatting on whether or not a cell has data in it.

You'd have to apply it to the largest range that you expect to use. If
c2:e35 is the largest range:

Select the range C2:E35 so that cell C2 is the active cell (C2 is not
"blueish" and all other cells in the range are)

Conditional Formatting
Formula Is: =LEN(C2)

Biff

"TUNGANA KURMA RAJU" wrote
in
message ...
My output range differs everytime. Formatting this range looks very
odd.I
have applied border,fill color to this range.How to apply conditional
format
to my variable range output. Sometimes my output range is
c2:e30,sometimes
c2:e35,sometimes c2:e17 like that.