I have a sheet where all columns use conditional formatting to highlight
rows where column D - Status contains specific text such as pending or
closed.

Also, column G has an IF() statement to calculate a date for completion
which depends on the text in column F i.e. depending whether the Risk is
Low, Medium or High.

The problem is that I have copied the formulas and conditional formatting
down to row 256. When I apply a custom filter to show only 'open' or
'pending' items - the table shows these fine, but it hides the blank rows
down to row 256. I say they are blank but they contain the formulas already
mentioned - to calculate the date for completion. The next available row to
enter data is 256, but this row has no formatting.

Does anyone know how I can make the rows continouous when filtered so that
when the 'closed' items are hidden the next available rows 22, 23 etc up to
255 are available to me, to enter data.

Kind Regards

Dylan Dawson
Glasgow

maybe, instead of specifying a custom filter for showing 'pending' or 'open'
items, specify it as:

does not equal "Closed" OR equals ""


Another suggestion might to give the blank rows a default status like "New"
or "Draft" instead of being blank.


--
Hope that helps.

Vergel Adriano


"dd" wrote:

I have a sheet where all columns use conditional formatting to highlight
rows where column D - Status contains specific text such as pending or
closed.

Also, column G has an IF() statement to calculate a date for completion
which depends on the text in column F i.e. depending whether the Risk is
Low, Medium or High.

The problem is that I have copied the formulas and conditional formatting
down to row 256. When I apply a custom filter to show only 'open' or
'pending' items - the table shows these fine, but it hides the blank rows
down to row 256. I say they are blank but they contain the formulas already
mentioned - to calculate the date for completion. The next available row to
enter data is 256, but this row has no formatting.

Does anyone know how I can make the rows continouous when filtered so that
when the 'closed' items are hidden the next available rows 22, 23 etc up to
255 are available to me, to enter data.

Kind Regards

Dylan Dawson
Glasgow

Does not equal "Closed"

So simple yet so much of a difference : )

Thanks Vergel

"Vergel Adriano" wrote in message
...
maybe, instead of specifying a custom filter for showing 'pending' or 'open'
items, specify it as:

does not equal "Closed" OR equals ""

--
Hope that helps.

Vergel Adriano


"dd" wrote:

I have a sheet where all columns use conditional formatting to highlight
rows where column D - Status contains specific text such as pending or
closed.

Also, column G has an IF() statement to calculate a date for completion
which depends on the text in column F i.e. depending whether the Risk is
Low, Medium or High.

The problem is that I have copied the formulas and conditional formatting
down to row 256. When I apply a custom filter to show only 'open' or
'pending' items - the table shows these fine, but it hides the blank rows
down to row 256. I say they are blank but they contain the formulas
already
mentioned - to calculate the date for completion. The next available row
to
enter data is 256, but this row has no formatting.

Does anyone know how I can make the rows continouous when filtered so that
when the 'closed' items are hidden the next available rows 22, 23 etc up
to
255 are available to me, to enter data.

Kind Regards

Dylan Dawson
Glasgow