Skip navigation

Conditional formatting rules

271 Views 3 Replies Latest reply: Feb 17, 2013 4:14 PM by rwleejr RSS
rwleejr Calculating status...
Currently Being Moderated
Feb 17, 2013 12:59 PM

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 Level 6 (12,630 points)
    Currently Being Moderated
    Feb 17, 2013 1:28 PM (in response to rwleejr)

    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 Level 7 (28,185 points)
    Currently Being Moderated
    Feb 17, 2013 1:58 PM (in response to rwleejr)



    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.




More Like This

  • Retrieving data ...

Bookmarked By (0)


  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.