Hello everyone!
So I have a column, it has a 3 color gradient conditioning formatting, high value 10, mid value 5, low value 0. They look as they should, however I want columns to the right to have the same color across their respective rows.
I though I could do this with format painter but it is not doing anything.
Any help?
Thanks in advance,
Juan
Don't use format painter - it's hit and miss at the best of times for CF. Just make sure that your CF formulae have the correct cell references (with and without $ as appropriate) and assign them to the appropriate ranges through the dialog. Make sure you are within the first column of your range when setting up your rules.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Wow! Thank you for the quick response.
Frankly, I don't know how to do this... I mean the columns to the right have no numbers just dates and other data, I just want the 3-color CF thats on the one column to apply to the others.
Juan
You'd have to attach a sample sheet for me to advise further. CF is a tricky thing to master, as many people discover.
Adjust your range in your CF rule to include the extra column, you shouldnt need to change anything else (except maybe make sure the cell you are basing it in, has teh column ref fixed 0 $B3, not just B3)
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks