Conditional Formatting
 

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

Conditional Formatting
 

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

"jen2018" wrote:

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

Conditional Formatting
 

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

"jen2018" wrote in message
...
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

Conditional Formatting
 

Thanks that's perfect!!

"Duke Carey" wrote:

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

"jen2018" wrote:

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