| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If statement based on cell formatting/style
Hi,
I am wondering if it is possible to do the following. I have an Excel sheet that is some sort of financial report. I want to have a function that would go... If CellFormat = Style1 then "H1" If CellFormat = Style2 then "H2" If CellFormat = Style3 then "H3" If CellFormat = Style4 then "H3" If CellValue = Total then "TL" Else the line is "LN" I'd then extend it to... if LN and (Row value = 0) then hide row. So it would hide rows if the 'resource code' is 0 The other option is to do it manually but was wondering if it's possible to do it via VBA. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF Statement based on first two characters of cell | Excel Programming | |||
| style sheets vs cell formatting | Excel Worksheet Functions | |||
| Fomatting a row based on style of a cell within the same row | Excel Programming | |||
| Conditional formatting based on if statement. | Excel Worksheet Functions | |||
![Steven North[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
