I'm looking for a way to get Numbers to change the color of a cell value depending on the result of a Formula:
Here's the logic:
If the cell "a1" is greater than 50 then change the color of the result of "b1" to red.
If the cell "a1" is less than or equal to 50 do not change color of the result of "b1".
By the way, cell "b1" is a SUM formula.
Any help would be appreciated.
Thanks
MacBook Pro 13″, macOS 10.14
Hi bj4mbp,
Perhaps this is what you want. Highlighting (red text) in B if the corresponding value in A is greater than 50.
Insert another column (Column C) to give something with which to compare Column B.
Formula in C2: IF(A2>50,B2,"")
Fill the formula down in C.
Now for the conditional highlighting. Select all Body Cells in B.
Regards,
Ian.
Conditional highlighting is your friend here,
Select the cells to be highlighted.
Click the Format brush to open the Formt Inspector in the right sidebar.
At the bottom of th Cell pane, click the Conditional Highlighting item.
In the CH pane, click Number, click 'is greater than'
Enter 50
Click the displayed action and choose Red text (or red fill) from the menu list.
Regards.
Barry
Using "if" in Numbers to change color of Result
