Apply conditional formatting to non-blank cells
 

I have a spreadsheet that is refreshed periodically and the data range
changes each time. I want to apply conditional formatting to non-blank cells
in columns D, F and H. So I guess I need to identify the number of rows in
the range and then loop through each cell in each of columns D, F and H and
apply the formatting.

How can I do this?

Grateful for any help.

Apply conditional formatting to non-blank cells
 

Why not apply conditional formatting to the whole lot?

For example:
Format Conditional Formatting : 'Formual Is'
... then in the formula box put
=NOT(ISBLANK(A1))
... and set a colour.

This will highlight the non-blank cells.

Similarly:
=ISBLANK(A1)

... can be used to highlight blank cells.

More info:
http://www.bygsoftware.com/Excel/Int...formatting.htm

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"Snowsride" wrote in message
...
I have a spreadsheet that is refreshed periodically and the data range
changes each time. I want to apply conditional formatting to non-blank
cells
in columns D, F and H. So I guess I need to identify the number of rows
in
the range and then loop through each cell in each of columns D, F and H
and
apply the formatting.

How can I do this?

Grateful for any help.

Apply conditional formatting to non-blank cells
 

Andy

Thanks - found a solution. There are 3 condional formats and a default thus
allowing 4 colours but if a cell is blank it has to be unformatted. Solution
involved a For..Next loop and some if statements.

Thanks

"Andy Wiggins" wrote:

Why not apply conditional formatting to the whole lot?

For example:
Format Conditional Formatting : 'Formual Is'
... then in the formula box put
=NOT(ISBLANK(A1))
... and set a colour.

This will highlight the non-blank cells.

Similarly:
=ISBLANK(A1)

... can be used to highlight blank cells.

More info:
http://www.bygsoftware.com/Excel/Int...formatting.htm

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"Snowsride" wrote in message
...
I have a spreadsheet that is refreshed periodically and the data range
changes each time. I want to apply conditional formatting to non-blank
cells
in columns D, F and H. So I guess I need to identify the number of rows
in
the range and then loop through each cell in each of columns D, F and H
and
apply the formatting.

How can I do this?

Grateful for any help.