Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to insert additional logic here ******
Sub HiLite() For Each cll In Range("A:A") If cll.Value = "C" Or cll.Value = "c" Then If IsEmpty(cll.Offset(0, 1)) Then cll.Offset(0, 1).Interior.ColorIndex = 6 _ Else: cll.Offset(0, 1).Interior.ColorIndex = xlNone If IsEmpty(cll.Offset(0, 2)) Then cll.Offset(0, 2).Interior.ColorIndex = 6 _ Else: cll.Offset(0, 2).Interior.ColorIndex = xlNone ***** If cells R - U are ALL empty, then high-light. R - U; if ONE of them is NOT empty then NONE of the cells are high-lighted ********* End If Next End Sub Thanks for any help!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Trouble with IF | Excel Worksheet Functions | |||
Still having trouble | Excel Discussion (Misc queries) | |||
Im in trouble!!! Please Help!! JS | Excel Discussion (Misc queries) | |||
still having trouble with this.... | Excel Worksheet Functions | |||
Trouble getting used to VBA | Excel Programming |