CODEWITHSUNDEEP
if-statementgoogle-sheetsgoogle-sheets-formulags-conditional-formatting
tbonehuber
tbonehuber

Reputation: 13

Google Sheet Conditional Formula for IF function

Trying to make a Google Sheets Formula for Conditional Formula that when a cell in column "A" is equal to then change the background to red if Cell in the matching row in column "E" is empty I started with REGEXMATCH but I couldn't figure out how to format it.

Excel

Basically, if the company's names match they require a PO# in which it would mark the cell red if not filled out

Upvotes: 1

Views: 100

Answers (1)

player0
player0

Reputation: 1

try:

=($A2<>"")*($E2="")

apply it on range A2:A

Upvotes: 1

Related Questions