| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need VBA for Conditional Format of Row
Hi guys,
I need VBA code to add to an existing macro. If column H has an "x" in it then I need that entire row highlighed as color 42 (light blue). Below is what I tried but it isn't working. Any help would be appreciated. Dim cfrange As range Set cfrange = range("h7:h700") If cfrange = "x" Then range("A:G").Interior.ColorIndex = 42 End If -- Danielle :<) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 : conditional format for 5 format settings | Excel Programming | |||
| Conditional Format overwrighting previous conditional format | Excel Programming | |||
| New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
| Multiple conditional on conditional format formula | Excel Programming | |||
| Keep format after paste from other worksheets - conditional format or EnableControl solution doesn't work | Excel Programming | |||
Threaded Mode
