Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have 4 columns, A B C D.

  • Column A has a designed value.
  • Column B has a reviewed value.
  • Column C is empty.
  • Column D has a formula which returns false if value in column A does not match value in column B. Also, Column D is always hidden.

I need help in highlighting the row or giving some color to column C if D has false in it.

share|improve this question
add comment

2 Answers

Select Column C, then click on Conditional Formatting -> New Rule and choose to "Use a formula": =$D1=FALSE. Pick how you want to format the cells like with fill color. This will highlight all the cells in Column C on the rows where Column D is FALSE. If you want to highlight the entire row, then highlight all the relevant columns (like A:C), then use the same formula.

If you want it to highlight cells if FALSE is in Column C or D, then use the formula: =AND($C1,$D1)=FALSE (this works if Column C is empty, or if Column C has true/false values in it).

share|improve this answer
add comment

http://www.excelforum.com/excel-general/799063-conditional-formatting-highlight-a-row-based-on-one-cell-value.html has this question. Highlight column c and replace A with D in your case. Note this only works in Excel 2010.

So if I understand you correctly, you want to highlight A1:J1 if A1 is "HIGH PRIORITY". And you want to highlight A3:J3 if A3 is "HIGH PRIORITY", etc.?

If so, select your full range, e.g. A1:J100, then set the conditional formatting rule to:

=$A1="HIGH PRIORITY"

The row number will properly adjust for the condition of each row, but the column will stay the same (A).

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.