Conditional Highlighting

Here's one way:

Column A contains the "cell(s) to the left.

Column B contains the cells to be highlighted.

Column C contains the values necessary to trigger the conditional highlighting of the cell in that row of column B.

the values in this column are determined by a simple formula:

The conditional Formatting rule applied to cells in Column B is shown in the sidebar to the right of the table.

Select all cells in column B, open the Conditional Highlighting pane, and set the rule as it applies to the first cell in B2

Regards,

Barry

Hank7373, see my uses of stacked tables in today's message at Locking Cells in Numbers - Apple Community. This might help you manage to do something similar.

Yes Excel allows formulas in conditional formatting, not Numbers.

Conditional Highlighting rules compare the value in the cell to be highlighted to a fixed value, written into the rule, or to a variable value, contained in a second cell.

In this case, the comparison value needs to be calculated, using the value in the cell to be highlighted.

As you want the highlight to be applied when the value in column C is equal to or greater than the (calculated) comparison value, and probably do not want empty cells like those in rows 9 and 10, I've included Rule 1 to prevent the red fill when the cell is empty, or contains zero.

Cell F2 contains a formula to calculate the minimum value needed in 'this row' to trigger the red fill:

=B2*1.2

Filled down to F10.

Column F (or whatever column you choose to hold the formula) may be hidden.

I used a Custom Style in the CH rule to use a brighter red than the one labeled "Red Fill" in the set of filll colours provided.

Regards,

Barry

Hi Hank,

Apologies for not getting back to you earlier!

Ifyou've solved the issue, please reply with a not that you've done so.

If not, can you provide a description of what you've tried and what happened when you tried it.

A screen shot of the part to the table containing the cells in question, and one of the formula as it appears in the formula editor would also be useful.

Regards,

Barry

hank3737 wrote:

Just two cells. I want C2 to be red if it is 1.2 times or more than what's in B2.

You need a third cell D2 containing the formula in Barry's post. To enter the formula, click D2, type = to call up the formula editor, click B2 so that formula editor automatically enters that reference, then type *1.2 and return. The cell will then contain the formula.

Then in a separate step select C2 and enter the highlighting rule.

You can then hide column D if you want.

SG