| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
if statement that tests format of cell
I am trying to create an if statement that tests the format of the
cell in addition to the value in the cell; specifically I want to test if the format of the text in the cell is superscript or not. I have been trying everything I know and this is what I have so far: ElseIf Trim(ActiveCell.Value) = "2" And Cells(ActiveCell.Value).FontStyle.Superscript = True Then sData = "0" Any help you could provide would be very much appreciated. Matt |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How Can i use the cell colors as logical tests? | Excel Worksheet Functions | |||
| Two Logic tests in an IF Statement | Excel Worksheet Functions | |||
| If statement - 2 tests | Excel Worksheet Functions | |||
| Average a group of tests for grade, some tests not taken by all. | Excel Discussion (Misc queries) | |||
| Cell tests for upper case, and certain #'s | Excel Programming | |||
Threaded Mode
