I have an excel spread sheet that I would like to use conditional formatting. On my Expenditures tab I want to auto highlight my automatic bills, on my data tab, I have the listed bills that auto pay. Can you help me with how to set this up please?
I have an excel spread sheet that I would like to use conditional formatting. On my Expenditures tab I want to auto highlight my automatic bills, on my data tab, I have the listed bills that auto pay. Can you help me with how to set this up please?
You can use a formula like this one:
You have tochose which color you want them to be.Please Login or Register to view this content.
Pierre Leclerc
_______________________________________________________
If you like the help you got,
Click on the STAR "Add reputation" icon at the bottom.
I tried putting that into the conditional formatting area and no luck...any ideas?
I did it for you in the attached file.
It could be the copy and paste of the formula that created some problem. I had to change the cell reference to I1 because it was copied as I10469???.
Awesome thanks, one last question...is there any why to have the fill run from the date to the amount....or will it just highlight the single cell?
All cells in that column will be highlighted if you have one of those expenses in them. You can limit its scope to a specific range if you like.
I was wanting to highlight the section or the row based on what one cell says...take a look at the excel doc and you will see what I am talking about. I don't know if it possible or not. But I was hopping to get the date to the amount highlighted....
Is this what you were looking for?
Sure is, how is that done?
In the "Conditional formatting rules manager" window, you have the opportunity to specify the range where this rule will be applyied to. In your case, it is from column G to column J.
You also need to make your formula columns' independant by putting a $ in front of the column letter in your formula. See the $ before the I1 reference in the formula.
You always write your formula using the first row of your applied range. As here, the conditional formatting is applied to the whole column, so I wrote the formula with I1 in reference.Please Login or Register to view this content.
It would be much faster to recalculate your worksheet if you limit this conditional formatting to a specific range as in your case it could be only from $G$9 to $J$38. In this case, the formula would have benn written with reference to cell I9 because it is in the first row in the applied to range.
A bit tricky but by experimenting, you get used to it.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks