| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2007 Excel conditional formating, reference cell containing specif
I need to add a fourth condition to an array. This fourth condition needs to
reference a cell only when that cell contains a specific text string. The preceding numbers will change, however the text will be based off of three sets of specific text. Basicaly N1 changes color if A1 CONTAINS xyz. N1 already changes color three ways based off of a date formula. Please advice. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
2007 Excel conditional formating, reference cell containingspecif
Set up a 4th rule for N1 with Formula Is:
=ISNUMBER(SEARCH("xyz",A1)) then set your format. Hope this helps. Pete On May 15, 11:45*pm, Lostinthought wrote: I need to add a fourth condition to an array. This fourth condition needs to reference a cell only when that cell contains a specific text string. The preceding numbers will change, however the text will be based off of three sets of specific text. Basicaly N1 changes color if A1 CONTAINS xyz. N1 already changes color three ways based off of a date formula. Please advice. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change formula RC to Cell reference value Excel 2007 | Excel Discussion (Misc queries) | |||
| Macro Cell Reference - Excel 2007 | Excel Discussion (Misc queries) | |||
| Conditional Formating in Excel 2007 | Excel Worksheet Functions | |||
| conditional cell formating | Excel Discussion (Misc queries) | |||
| Expanding conditional formating with reference cells changing | Excel Discussion (Misc queries) | |||
Linear Mode
