PDA

View Full Version : Define Certain Exact Range



sal21
08-05-2004, 03:37 AM
This file contain 2 sheet and a macro that colorize a column.

my problem is possible to colorize entire column saturday and sunday in grey to the last useful record is present i column A of sheet PRIMO_SEMESTRE and SECONDO_SEMESTRE? I have insert the condition to colorize until 15000.

In my case i wuold want to colorized column to end in line 811...

My idea is to make a control if in the column A is present a number, or another value....(boh!?)

Jacob Hilderbrand
08-05-2004, 04:25 AM
Try conditional formatting. Select the entire A Column.

Format | Conditional Formattine

{Formula Is}

=LEN(A1)>0

Then change the format as needed. If there is any number or text in the cell it will be formatted as you specify. If the cell is blank it will not be changed.

Richie(UK)
08-05-2004, 05:18 AM
For reference, see also:

http://www.mrexcel.com/board2/viewtopic.php?t=100133