Formating

[stevekirk]

hi,

i have a condition format that = isblank(e6). if the cell is empty it turns green
what i really need is that it turns green if d6 is also empyt but if d6 is not empty and e 6 is do not turn it green

this will be copied to all cells in column e

thanks
steve

[Carim]

Hi,

Please Login or Register  to view this content.

HTH
Carim

[Carim]

oops ...

about the copy ... is the copy relative or absolute ?

Carim

[stevekirk]

Thanks carim

working great

steve

[Carim]

Glad your problem is solved

Thanks for the feedback

Carim