On 13 Aug., 14:09, "Bob Phillips" wrote:
Alternative suggestion.

Select A2:D5
menu FormatConditional Formatting
Change Condition1 to Formula Is
Select FormatFont
Change Color to white
exit


Hi Bob,

I tried it but it did not do what I wanted.
Notice that from 5rows of data I want to get 13rows of data, this
conditional formatting formats only the cells, does not add, move etc
the cells with values

chris