Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional format problem
This code is supposed toset a conditional format to "hide" the contents of a
cell if the following line has the same date: Sub test() Dim strRange As String Dim strCondition1 As String For x = 2 To 7 strRange = "L" & x Debug.Print strRange strCondition1 = "=DAY(A" & x & ")=DAY(A" & x + 1 & ")" Debug.Print strCondition1 With Worksheets("Time sheet for submission").Range(strRange).FormatConditions.Add( xlExpression, , strCondition1) With .Font .ColorIndex = 3 End With End With Next End Sub I set sthe Debug.Print lines to try to understand where the code is going wrong, but I still can't figure it out. On the face of it, the code should work, especially given the output I got in the Immediate window: L2 =DAY(A2)=DAY(A3) L3 =DAY(A3)=DAY(A4) L4 =DAY(A4)=DAY(A5) L5 =DAY(A5)=DAY(A6) L6 =DAY(A6)=DAY(A7) L7 =DAY(A7)=DAY(A8) This is as expected, but the forumlae in the spreadsheet reference the wrong lines after the first instance as below. Conditional format contents: L2 refers to A2 A3 as expected but L3 refers to A4 A5 instead of A3 A4 - - - L7 refers to A12 A13 Can anyone suggest a cure for what's happening here? -- Ian -- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format Problem | Excel Discussion (Misc queries) | |||
Conditional Format Problem | Excel Discussion (Misc queries) | |||
Conditional Format Problem. | Excel Discussion (Misc queries) | |||
Conditional format problem | Excel Discussion (Misc queries) | |||
help please with conditional format problem | Excel Worksheet Functions |