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.