Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting / blank cells | Excel Discussion (Misc queries) | |||
conditional formatting for blank cells | Excel Discussion (Misc queries) | |||
Conditional formatting/non blank cells | Excel Worksheet Functions | |||
Apply conditional formatting to cells formatted as percentages? | New Users to Excel | |||
How to apply conditional formatting on group of cells by using dat | Excel Discussion (Misc queries) |