I'm trying to create a formula in excel that checks two separate columns before applying the color change to one of those columns. I see tutorials on how to do this in Excel 2007, but have yet to find an easy way of doing this in 2010.
For an accurate example: In Column D we check "N" if someone is missing a specific document. In Column N of the same row, we specify what documents they are missing, but if nothing, we input "Complete".
What I want to figure out how to do is: If Column D says "N" and Column N of the same row says "Complete", I want Column N to use the Light Red Fill with Dark Red Text.
Can anyone help or direct me on how manually input this code in the future?