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,
Positive: 95 %

Possible answer

Conditional formating - apply on more cells ... Conditional formatting based on another cell; ... Color Row based on value in a Column ...
Read more
Positive: 95 %
Conditional Formatting: ... Figure 1. The Conditional Formatting Rules Manager dialog box. ... Format all cells based on their values.
Read more
Positive: 90 %
Applying conditional formatting to multiple cells in a Column ... 1 so...Change the formula in your conditional ... conditional formatting to multiple ...
Read more
Positive: 76 %
conditional formatting based on ... formatting based on other cell (over multiple cells) ... conditional formatting for the 2nd column ...
Read more
Positive: 53 %

Show more results