![]() Subsequently I tried copy and paste special but it still does not However even though it appears the conditional formatting was copied, now it will not work. Sheet for each month and used the Move/Copy function on the tab to create the additional sheets. ![]() Created this sheet in May and after much research and deliberation was able to get the conditional formatting to work then I realized I wanted a different Have a sum at the end of this column that reflects the total amount remaining to be paid for the month. However for ease of viewing I used conditional formatting to highlight the row once the bill was paid for the current month and an "IF" statement in a column to change the amount to zero for that row when it was paid -I ![]() I used Data Validation for a drop down list = Months so that I could select the month paid rather I am using Office 2010 and created a spreadsheet that I use to track monthly bills to reflect them as paid and show a remaining amount outgoing for the month. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |