Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I'll try to explain my problem. In column A i can have 5 different numbers: 1,2,3,4 and 5. So the value of any cell in column A (except for rows 1,2,3,4,5 - they are heading rows ) can be 1 to 5. Row 1,2,3,4 and 5 are heading rows. This is what i would like: when I'm in some row (for example row 34 - and the value of cell A34 is for example 3), and certain column(lets say column H), I would like cell H3 to become let's say bold(or change background color or both) - H3 because when the value in cell A34 is 3 that means that heading row 3 is used and needs to be bolded (but now the whole row just the cell above my selected cell but in the appropriate heading row - so if A34 is 1 cell H1 will be bolded and so on). I have some knowledge of VB so if I need to use VB here I think i could manage. If you have any sugestions it would mean a lot to me! If you don't understand :) my problem plese say and I'll try to explain again :) Cheers, Marko vaco |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting on "Any Text" entered in a cell | Excel Discussion (Misc queries) | |||
"justify across selection" cell formatting | Excel Discussion (Misc queries) | |||
Excel 2003: Conditional Formatting using "MIN" & "MAX" function | Excel Discussion (Misc queries) | |||
conditional formatting "if part of cell contents contains string" | Excel Worksheet Functions | |||
excel should "paste special" a "conditional formatting" | Excel Programming |