I have conditional formatting set up on a column of dates to higlight when the date is coming up to a 5 year renewal mark. However I need to be able to change toe formaula for formatting according to the text value in a different column
For example, my date column has been conditionally formated to turn red if the date is more than 5 years old. I want to link the formatting formula to another column that states client type. So if client is an individual, then turn the date column red when its 5 years old. If the client is a corporation, I need to the date to turn red if the date is 1 year old
Im struggling putting to seperate "IF" functions into the same cell. Can anyone help?
No comments:
Post a Comment