Conditional Formatting

[jen2018]

Column L has some email adddresses in it. I would like the row to be a
different colour if an email address has been entered or stay unfilled if an
address hasn't been entered. Is this possible?

If not then just changing the colour of the cell in column A would help

 

[Duke Carey]

Is column L always either blank or filled with an email address? In other
words, what if the entry in column L is something other than an email address?

Assuming you are dealing with a simple either/or:

select the range you want formatted & take note of the active row
Format->Conditional Formatting
select Formula is and use this formua (assumes the active row is 2)

=Not(isblank($l2))

Click on the Format button and choose the fill color
OK back to the worksheet

 

[David Biddulph]

CF/ Formula Is:
=ISNUMBER(FIND("@",$L1))

 

[jen2018]

Thanks that's perfect!!

Is column L always either blank or filled with an email address? In other
words, what if the entry in column L is something other than an email address?

Assuming you are dealing with a simple either/or:

select the range you want formatted & take note of the active row
Format->Conditional Formatting
select Formula is and use this formua (assumes the active row is 2)

=Not(isblank($l2))

Click on the Format button and choose the fill color
OK back to the worksheet