title: Color coding of a specific cell using "Conditional Formatting"
body: <p>I have a set of data like below:</p>
  
  <pre><code>        A
  1      10
  2      34
  3      30
  4       5
  5      35
  6      45
  7      60
  8      21
  </code></pre>
  
  <p>If I wish to find the maximum of the numbers under the A column and also match the row number corresponding to such max. number; I use:  </p>
  
  <pre><code>=MATCH(MAX(A1:A8),A1:A8,0) 
  </code></pre>
  
  <p>will give me (in the current cell): 7 (max. is 60 corresponding to row 7)
  Now, I wish to "color code"that number (i.e 60)<br>
  when I use "Conditional Formatting" in Excel;  </p>
  
  <ol>
  <li>I select A1:A8   </li>
  <li><p>I go to "Conditional Formatting" and select"New Rule" and then "Use a Formula to determine which cells to format" and under "Format values where this formula is true" I type in:  </p>
  
  <pre><code>=MATCH(MAX(A1:A8),A1:A8,0) 
  </code></pre></li>
  </ol>
  
  <p>and then click on the  "Format" button to select my color (say yellow).<br>
  However, I find that all the numbers under column A are now color coded (filled) with yellow color where as I only wish number 60 to be yellow. How can I do this?</p>