قالب وردپرس درنا توس
Home / Mac / How do I mark a cell based on other cells?

How do I mark a cell based on other cells?



Mac Numbers Version 5.1 (Yosemite)

I just need a simple formula that will mark a cell based on the difference between two other cells.
] Cell N9 would "fill" if P17> J17. I would customize 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 assume P17-J17> = 1 works for Cell N9)
I'm new to formulas and don't know the language … yet.
Any help will be appreciated.

Thanks!


KingB84


Source link