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