title: Formating an Excel cell for its value and data type
body: <p>How do I change the color of a cell based on its data type (e.g. percentage or number) and range of value (e.g. 20% to 40% turn yellow, green for below 20%, and red for above 40%) in that cell?  Also, how do I apply this rule to the entire sheet?</p>
  
  <p>Could not use conditional formatting for this scenario (mulitiple conditions i.e. data type and multiple data ranges).</p>
  
  <p>Office 2007 - Office 2010</p>
  
  <p>Scenario:</p>
  
  <p>The spread sheet contains same information in different ways e.g. Institution names are in row 1 and the total head conts for each institution are in row 2. then column A is for skill type. At the junction of each row and column there are number of persons in one cell and % of skilled persons out of the total head count (from row 2) in adjacent cell. And then, highlight the cells based on the criteria I mentioned above (turingin cells to green, yellow, and red based on the % range)</p>
  
  <p>There is a Cell function with "format" parameter (=cell("format",A1) = "P2") that I tried to use, butm then how do I use this in AND or IF function with a check on data type and ranges of value in those cells.</p>