W
Whit
New to Office 2007, but am very frustrated. When I copy a cell's formatting
(either by paste/special/formats or format painter) the conditional
formatting is not using the relative cell row reference but instead always
referring back to the original cell even though I am not using the absolute $
reference. For example:
CF = A10>100 (in cell A10)
when I copy the format to B10 CF = A10>100
If I copy the format to B10:F10 CF in all cells = B10>100
What is going on??
(either by paste/special/formats or format painter) the conditional
formatting is not using the relative cell row reference but instead always
referring back to the original cell even though I am not using the absolute $
reference. For example:
CF = A10>100 (in cell A10)
when I copy the format to B10 CF = A10>100
If I copy the format to B10:F10 CF in all cells = B10>100
What is going on??