No it doesn't, that is why I called it an alternative. It does pick out the
data though IMO.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"ciapecki" wrote in message
ups.com...
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