Conditional Formatting in Numbers

I would like to formatting the cells in Numbers which have the same text. It should be so easy to do it but somehow I couldn't find the solution. There are some other functions of conditional formatting but not of that.

Posted on Oct 18, 2023 4:30 AM

Reply
5 replies

Oct 18, 2023 4:34 AM in response to alper979

alper979 wrote:

formatting the cells in Numbers which have the same text.


Could you explain what you mean by that, perhaps including a screenshot. shift-command-4, drag to select area, release, start new post here and use the mountains-and-moon 'Image insertion' icon below the compose window to insert the screenshot from the Desktop.


SG

Oct 18, 2023 11:10 PM in response to Yellowbox

Hello Ian,


Thank you so much for the reply, your's one works but not the I was looking for.


Let me explain my situation a bit more.


As you can see on the attached file, there is one column and includes various datas. I would like to highlight the repeated ones.


I could do this easily in Excel as there is only one button to do that but I couldn't find that option in Numbers.


Thank you



Oct 19, 2023 1:20 AM in response to alper979

Hi alper979,


Add two Helper columns (you can hide these when all is working well).

Column C finds the repeats.

Formula in C2: COUNTIF(B$1:B2,B2)


Column D gives comparisons for the Conditional Highlighting.

Formula in D2: IF(C2>1,B2,"")


Conditional Highlighting: Select all Body Cells in Column B.


As all Body Cells in Column B were selected, Numbers will fill that rule down and adjust the cell references.



Hide the Helper Columns C and D.


Done!

Ian.



Conditional Formatting in Numbers

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.