MacMusic  |  PcMusic  |  440 Software  |  440 Forums  |  440TV  |  Zicos
cell
Search

How Do I Highlight a Cell Based On Other Cells?

Saturday May 18, 2019. 04:24 AM , from MacMost
Mac Numbers version 5.1 (Yosemite)
I just need a simple formula that will highlight a cell based on the difference between two other cells.
Cell N9 would “fill” if P17>J17. I would adapt the formula to fit the other cells in column N.
Example: N1 would fill if P17-J17>=2 N2 would fill if P17-J17>=3 etc. (I guess P17-J17>=1 works for Cell N9)
I am new to formulas and don’t know the language…yet.
Any help would be appreciated.
Thanks!
—–
KingB84
https://macmost.com/forum-how-do-i-highlight-a-cell-based-on-other-cells.html
News copyright owned by their original publishers | Copyright © 2004 - 2024 Zicos / 440Network
Current Date
Apr, Sat 20 - 00:29 CEST