3 Replies Latest reply: Feb 17, 2013 4:14 PM by rwleejr
rwleejr Level 1 (0 points)

How/Can I define conditional formatting rule that will fill a cell with a specific color if the value of that cell (nummeric) is equal to or less than x% of the value in another numeric cell?

MacBook Pro, iOS 5.1, Conditional formatting rules
  • Wayne Contello Level 6 (17,564 points)

    1) select the cell(s) you want to apply conditioanly formatting to then

    2) select the menu item "Format > Show Conditional Format Rules"

    3) then make the appropriate selections:

    Screen Shot 2013-02-17 at 3.28.04 PM.png

    besure the click the "Edit" button to change the formatting selections for the condition you selected then click "Done"

  • Jerrold Green1 Level 7 (29,960 points)



    That sort of test is not supported in Conditional Format. You can test for equal to, less than, greater than and so forth, but you can't do math in the comparison specification, as in your percentage calculation. You can do that calculation in another cell and then compare the cell being formatted to the cell with the calculation.



  • rwleejr Level 1 (0 points)

    Thanks Jerry.  I was afraid that was the answer.