| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Hybrid Mode
