Conditional Formating

Hi everyone,
I want to display in Col G2 (MISS ADDRESS)
and in Col G3 (ADDRESS OK)

Find attach sshot

Thanks

Bakar

Hello,

This has nothing to do with Conditional Formatting. Conditional formatting changes the appearance of a cell based on certain conditions. In this case, you just want to calculate a cell value to be either "Address OK" or "Miss Address". This can be done with a simple IF() statement in the target cell.

Starting in G2 and copied down:

=if(D2<>"","Address OK","Miss Address")

Which means: If the cell in Column D in the current row has a value other than an empty string ( the ""), display the text "Address OK", otherwise (that is, if column D of the current row has no text), show "Miss Address"

does that help?

cheers,