up and Down arrow with figure % and value of the precentge same screen shot which I mentioned in Excel

What was discussed in this conversation is not a 'formula', which is the code in the cell that produced the value to which the Custom format was applied.

You can copy this custom format and paste it into a Table in another Numbers document.

"…if I open new Number sheet and search about it I can't find this formula under Data Format."

Correct. Custom Formats and Custom Styles are unique to the document in which they were created and applied. You can, though, COPY the format/Style of a cell, then Paste that style to another cell in the same Table, in another Table on the same sheet or on a different Sheet in the same Document or in a Table on a Sheet in a different Document.

When pasted in, the custom format should be available to any cell of the same Data type in that Document, and should be findable in the Custom section of the Data Format menu under the name you gave it when initially saving it.

Regards,

Barry

To copy a format, select a cell to which the format has been applied, then press option-command-C to copy the format of that cell.

Then go the the other document, click on the cell that is to receive the custom format, and press option-command-V to paste the format (Style) to that cell. Repeat with any other cells that are to receive the same custom format.

In Numbers you can use Custom Format.

And Conditional Highlighting:

SG

The number in each cell is from whatever formula you are using. If they are all 0.4 then the formula is not correct.

The custom format needs a % on the end of it. Drag the "K" to each line then click on it and choose %. If you want your percentages rounded to the nearest whole number, remove the ".##"

The arrows are ▲ and ▼ which you can copy/paste from here if you don't already have them. They don't look the same size when the font is Helvetica Neue. They do when it is Arial.

No calling, just posting.

The formula you posted, (K5-K4)/K4, is the correct idea for row 5. Check the other rows and see if their formulas are correct for their rows.

If you imported this document from Excel, the formulas AND the formatting should have imported. I just tried it and had no problem.

This was the imported format

The imported highlight rule was "if less than 0 then 'custom style' red text"

Hi. Your screenshots seem to indicate that you are not following the example I provided. Perhaps you could try to reproduce it exactly and then go on from there.

SG

It is really just a matter of making sure your Custom Format settings look exactly like those in my screenshot.

You can read basic instructions on Custom Format here.

SG