Most valuable professional
  • Hot Topics

Excel Combining IF + AND to Highlight Cells (Conditional Formatting)

Hello! I am using a formula to calculate the number of days between two dates, and then highlighting cells based on that number: =(DATEDIF((B5-44),B3,?D?))>179 -- if the number of days between two dates is greater than 179, then highlight a cell. This formula is working great for me, but I have come to an area of the spreadsheet where I need to add a second variable into the mix. Basically, I want something that combines the formula above with something like AND B4="Experienced" and then use the new formula to determine whether or not to highlight a cell. (i.e. If the number of days between two dates is greater than 179, AND B4="Experienced", then highlight a cell.) Does that make sense? Can anyone help? Excel keeps finding different ways to tell me that my new formula is garbage. Thank you

This question generated 23 answers. To proceed to the answers, click here.

This thread is current as of June 10, 2015.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel