FIND THE ANSWERS

Conditional Formatting for multiple cells based one 1 column?

Answer this question

  • Conditional Formatting for multiple cells based one 1 column?


Answers

Answer #1 | 24/12 2013 01:31
For cell B2 the formula is: =IF(B2=$A2,TRUE,FALSE) That needs to apply to ... =$B$2:$E$32 ... if the data in your example were complete. If you get one cell right you can use the format painter for the rest,

Possible answer