Hello,
Im trying to make an excel sheet to help manage my bills.
my objective is to apply conditional formatting to the "Date Payable" Column. So if todays date approaches within 5 days of the Date Payable date the cell would turn red....
I understand how to manipulate the colors etc.. I need your help in order to make a forulma to put in the conditional formatting new rule box...
I was also wondering it is possible to use conditional formatting to format an entire row, based on the value of one cell in that row?
Thank you very much your help, it is greatly appreciated..
Bookmarks