Hi,
I want to copy a conditional format that has a formula with an absolute reference. When I make the reference relative, the formula doesn't work so I need to copy it with the absolute reference. The problem is that the conditional format doesn't work the way I want it, because the other cells refer to the absolute cell.
How to copy conditional format with absolute reference?
Attached an example.
Thanks
Where do you want to copy it to?
Have you tried changing the abs ref from =$E$2 to just =$E2?
To have the CF refer to the other rows, adjust the APPLIES TO range from =$A$2:$E$2 to maybe =$A$2:$E$10
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks for the reply.
The Abs ref =$E2 and APPLIES TO range =$A$2:$E$10 works if I select the row and use Format Painter.
Thanks for the tip!
Last edited by Okoth1; 11-10-2016 at 05:07 AM. Reason: typo
Good stuff, happy to help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks