So I created a conditional formatting on one cell but want to drag it and apply to other cells as well. So here is an example that I attached. You will notice my conditional formatting is still based on columns/rows "C3 to E3" but when I drag it down to the other cells down I want it to automatically change to C4 to E4, C5 to E5 etc...
Any help will do thanks
Did not open your file (yet), but to appl CF to a range, select that range in the Applies To box in the 1st CF window
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
Sorry I don't follow in what your saying :S
When you open the CF window, and you see your rule/s, just to the right of each rule is a box that is headed Applies To
That is where you specify the range that the CF will be applied to
Hmm...I don't think I was clear.
It is more on the =SUM($C$3:$E$3) so not where the range applies ...its more on the left side....you know how you create a formula and drag it down so it applies to each set of rows...more like that in the conditional side of things when you want it to apply to the other rows instead of doing it manually for each row...
so I want the next one to be =SUM($C$4:$E$4), =SUM($C$5:$E$5), etc...
so what happens when i drag the conditional formatting it says at =SUM($C$3:$E$3) which I don't want even when I change =SUM($C3:$E3)....removing the $ signs so hoping it would change to the next row # but it doesnt do that ....
Last edited by aqalna; 10-19-2016 at 04:16 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks