I have a spreadsheet with three columns, each column listing the folder names found on a server.
Server1 | Server2 | Server3
--------|---------|---------
A | | A
--------|---------|---------
B | B | B
--------|---------|---------
C | |
Highlighting the 'C' values is easy, but I would also like to highlight the 'A' values. I'm quite sure that I'm not able to do it using only point and click in the GUI, but correct me if I'm wrong.
So bottom line, my question is:
How can I add conditional formatting to cells containing text where the value is found in N or less cells, where N is greater than 1?
Additional information
In Excel I do:
In Excel if I select:
- Home -> Conditional Formatting
- New Rule
- Select a Rule Type -> "Format only unique or duplicate values" and "Edit the Rule Description" --> Formal all: unique
- And select for instance Bold as the format
It will result in the C value to be highlighted.
Which formula can I apply if I select "Use a formula to determine which cells to format" in order to have the A'values highlighted?