Google-sheets – Conditional Formatting in Google Spreadsheet

conditional formattinggoogle sheets

I have a list of addresses in column C for work orders, I'd like them to be highlighted if there are duplicates so we don't forget a work order on each visit. These work orders/results are dynamic and the list will change daily.
Can I just do it using a formula or do I need a script?

Best Answer

In Format, Conditional formatting... the following should achieve what you request:

WA58956 example

where "Custom formula is" contains:

=countif(C:C,C1)>1

and Range may be set to C:C - or adjusted to suit.

Related Solutions

Google-sheets – Google spreadsheets Conditional Formating Formula

Please try:

is not equal to A$1 for Range A:A.

It is not case sensitive however.

Google-sheets – Set conditional formatting on a column that depends on another cell’s text (not value)

Since you use the date value, we have a nice weekday() function we can make use of.

weekday(*yourDate*,2) will give you an integer from 1-7 counting from Monday. On the conditional formatting applied to your targetted range, we can then use the following custom formula to highlight weekends:

=weekday(B$1,2)>5

Best Answer

Related Solutions

Google-sheets – Google spreadsheets Conditional Formating Formula

Google-sheets – Set conditional formatting on a column that depends on another cell’s text (not value)

Related Topic