Google-sheets – How to check and replace cells

conditional formattinggoogle sheetsif-this-then-that

I need help trying to figure this out. I am extremely new to formulas and very confused.

Here is my thought process:
IF B1 contains a comma AND C1 is exactly "none" THEN I want C1 to be replaced with "USA".

Do I need a new column to make this happen? or could I some how use Conditional formatting? I've really only used formulas in Conditional Formatting so I'm not sure where to start.

Here is the link to a spreadsheet if you need it
https://docs.google.com/spreadsheets/d/1cHtJg04BLrwvWBFaqy5VeSRJSjlA9qQcnNePZLI8u7M/edit?usp=sharing

Best Answer

You could use the following formula in cell D3 (or anywhere else you may need to).

=IF(AND(REGEXMATCH(B3, ","),C3="none"), "USA","Oops")

(Of course you can change "Oops" to whatever you like or even a blank cell"")

Related Solutions

Google-sheets – Advanced matching in duplicates

Please select A26:B124 and apply a Custom formula is of:

=countif(E:E,$A26)+countif(G:G,$A26)

with the addition of further countifs to suit you and your choice of formatting.

COUNTIF

Google-sheets – Problem with conditional format of a calendar like table

Exactly why your formula does not work I do not know, but I think this version does:

=AND($A4+COLUMN()-2>=$A$1,$A4+COLUMN()-2<$A$2)

This might be counted as an explanation of sorts:

You cannot use Named Ranges directly in conditional formatting, you need to reference them indirectly.

I suspect it is to do with security/permissions.

Best Answer

Related Solutions

Google-sheets – Advanced matching in duplicates

Google-sheets – Problem with conditional format of a calendar like table

Related Topic