| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting contains?
is there any way to use conditional formating if a cell contains rather than equals. For example highlight all cells that contain a 1 somewhere in the number. so all these would highlight 10009 59991 91100 -- yorkshirewhite ------------------------------------------------------------------------ yorkshirewhite's Profile: http://www.excelforum.com/member.php...o&userid=31448 View this thread: http://www.excelforum.com/showthread...hreadid=511367 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional Formatting contains?
Use a condition of Formula Is and a formula of
=ISNUMBER(FIND("1",A1)) -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "yorkshirewhite" <yorkshirewhite.232thm_1139680501.7105@excelforu m-nospam.com wrote in message news:yorkshirewhite.232thm_1139680501.7105@excelfo rum-nospam.com... is there any way to use conditional formating if a cell contains rather than equals. For example highlight all cells that contain a 1 somewhere in the number. so all these would highlight 10009 59991 91100 -- yorkshirewhite ------------------------------------------------------------------------ yorkshirewhite's Profile: http://www.excelforum.com/member.php...o&userid=31448 View this thread: http://www.excelforum.com/showthread...hreadid=511367 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
| 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 that will display conditional data | Excel Worksheet Functions | |||
Linear Mode
