Luis Garcia
New Member
- Joined
- Jun 8, 2010
- Messages
- 3
Step1: Select range 'A1:B5'
Step2: Fill with numbers
Step3: Apply this FormatCondition:
Formula '=A1=2', with Red Font.
Then, all cells with contains number 2 are Red.
Step4: Select cell 'B2'
In VBA, Excel 2003:
Msgbox ActiveCell.FormatConditions(1).Formula1 shows:
'=B2=2'
In VBA, Excel 2007:
Msgbox ActiveCell.FormatConditions(1).Formula1 shows:
'=A1=2'
I have a Worksheet with ALL depends of this behavior!!!
I evaluate '.Formula1' for each cell in range, but in XLS2007 evaluates wrong values!!!
I need Help
Step2: Fill with numbers
Step3: Apply this FormatCondition:
Formula '=A1=2', with Red Font.
Then, all cells with contains number 2 are Red.
Step4: Select cell 'B2'
In VBA, Excel 2003:
Msgbox ActiveCell.FormatConditions(1).Formula1 shows:
'=B2=2'
In VBA, Excel 2007:
Msgbox ActiveCell.FormatConditions(1).Formula1 shows:
'=A1=2'
I have a Worksheet with ALL depends of this behavior!!!
I evaluate '.Formula1' for each cell in range, but in XLS2007 evaluates wrong values!!!
I need Help
