| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting with VBA
I though this would be easy, but I can't get it right, any help would be
greatly appreciated. I'm trying to go down Column "D" (about 250 rows) and when the contents of a cell = "HOURS" go to each cell to the right (31 cells) and if the contents of that cell = 9 then colour(color) the font red. Then continue down Col "D" and so on. I can get the Macro to get to the cell containing "HOURS", but after that nothing works, so I'm stumped. Eventually I will have many more conditions that just the one above, so I can't use Conditional Formatting, and in fact I don't want to. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200805/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
| Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Threaded Mode
