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.
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.
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
Hi alper979,
Is this what you want? I used Text contains. Note the $ symbol to Preserve Row in the reference to the Highlights table.
If this helps, please reply and ask for more details on the method.
Regards,
Ian.
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
Hello, could you look at the botton please where I explained it a bit more.
Conditional Formatting in Numbers
