I have the following situation:
Sheet A has many cells with conditional formatting:
> some of these cells use 'formula to determine which cells to format'
> other cells use 'format only cells that contain'
Everything works fine, formatting changes according to changes in the data!
Now I copy a range of sheet A to sheet B using VBA, that works OK.
However: in sheet B the conditional formatting of these cells is not working correctly anymore:
> cells using 'format only cells that contain' work correct! formatting changes correctly when data changes
> cells using 'formula to determine which cells to format' do NOT work correctly: the formatting is not being changed when data changes....
Looking at the conditional formatting rules on sheet B: everything looks fine, rules are ok, cell references are OK, formulas OK.
I'm using Excel 2013 on Win 10.
Is there any solution for this problem??