3 Replies Latest reply: Feb 17, 2013 4:14 PM by rwleejr
rwleejr Level 1 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
  • 1. Re: Conditional formatting rules
    Wayne Contello Level 6 Level 6 (13,620 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"

  • 2. Re: Conditional formatting rules
    Jerrold Green1 Level 7 Level 7 (28,995 points)

    RW,

     

    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.

     

    Jerry

  • 3. Re: Conditional formatting rules
    rwleejr Level 1 Level 1 (0 points)

    Thanks Jerry.  I was afraid that was the answer.

     

    Bob