Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If the cell contains..., do something
If the cell contains..., do something
Hi. 1) How to do the following: a) If the cell starts with "senior", do something... (eg count that cell if the cell starts with "senior") b) If the cell has "March" in the middle, do something... c) If the cell ends with "boy", do something... d) If the cell contains the word (it doesn't matter where the word locates), do something... ?? 2) Can you answers in Q1 be used in "conditional formatting"? I need these conditons to format my cells too! Thank you! -- Additional information: - I'm using Office XP - I'm using Windows XP |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
Adding a row to worksheet does not update cell references in another. | Excel Worksheet Functions | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel |