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" <(E-Mail Removed)> wrote in message
news:50F1D743-3E74-49BF-B0A8-(E-Mail Removed)...
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
>
>
>