I'm using the following formula in A1: =DATEDIF(A1,TODAY(),"M")>=18
When I try to use format painter to copy the conditional formatting to B1:B20, the formula sticks at =DATEDIF(B1,TODAY(),"M")>=18 all the way across.
It works when I paint one cell at a time.
Is there another way to copy down/across conditional formatting to not have "paint" one cell at a time?
In Excel 2007 forward, the formula will be based on the cell in the upper left corner of the range, and the formula will be same for every cell. This can be confusing when you are looking at B20 and the formula refers to B1, but you have to look at the applicable range of B1:B20, not just the one cell. Think of B1 as "the cell to which this formula applies" rather than "B1". Similar logic applies if you use absolute references. For example, $B1 would be "the cell in column B of the row containing this cell".
Bottom line is that your formula will work the way that you want it to.
If this isn't clear I can launch into a longer explanation.
Ohh I see it now. Thanks for pointing that out, i was getting frustrated!
Much appreciated!
Here is a more detailed explanation I wrote, maybe this will help.
http://seiglefamily.com/excel/condformat.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks