| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
If cell is Bold then 1, if cell is Italics then 2?
I have a list of hundreds of cells, the cells are either Bold, Italics, or
Regular. I want those cells that are bold to result in 1 in another column. those in italics to will result in 2. Am I able to write a "if" function that achieve this? If not, what should I do? Please kindly advise |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If cell is Bold then 1, if cell is Italics then 2? | Excel Discussion (Misc queries) | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| How do I get one cell to record the time another cell was changed. | Excel Discussion (Misc queries) | |||
| Display actual contents of cell | Excel Discussion (Misc queries) | |||
| copy a cell value not its function | Excel Discussion (Misc queries) | |||
Linear Mode
