Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
With this expression the program look the first cell of 3 cell an if find
"ACT" or "DEACT" paint this 3 cells of Yelow . If ThisWorkbook.Sheets("list").DrawingObjects("Check Box 9").Value = xlOn Then If InStr(1, Sheets("Grid").Cells(I, L).Value, "ACT") 0 Or _ InStr(1, Sheets("Grid").Cells(I, L).Value, "DEACT") 0 Then 'interior color yellow For Alarms: WARN and ALT Sheets("Grid").Cells(I, L).Interior.ColorIndex = 6 Sheets("Grid").Cells(I, L + 1).Interior.ColorIndex = 6 Sheets("Grid").Cells(I + 1, L).Interior.ColorIndex = 6 Sheets("Grid").Cells(I + 1, L + 1).Interior.ColorIndex = 6 But what I need is paint on yellow if he find a word "(CC)" in the third cell Well my question is . can I have a search or find instead of Value, "ACT" ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
instr() ? | Excel Programming | |||
Can I save to hard drive AND my flash drive at the same time? | Excel Discussion (Misc queries) | |||
InStr | Excel Programming | |||
InStr | Excel Programming | |||
Having a hard time with listbox | Excel Programming |