conditional format

T

TUNGANA KURMA RAJU

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.
 
B

Biff

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
 
T

TUNGANA KURMA RAJU

Thank you Biff,you are great really!

Biff said:
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
Click to expand...
 
Top