Saturday, April 25, 2015

Excel Conditional Formatting Formulas

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

linux - How to SSH to ec2 instance in VPC private subnet via NAT server

I have created a VPC in aws with a public subnet and a private subnet. The private subnet does not have direct access to external network. S...