Conditional Formatting not working

hmcnamara95571 ✭✭✭✭
edited 12/09/19 in Smartsheet Basics


I've created conditional formatting rules that are not working.  They work if I set the rule to "is not equal to" but when I set them to "is equal to" they stop working.  The spreadsheet contains "#NO MATCH" cells automatically formatted from another sheet. I want the "#NO MATCH" cells to turn red (not the whole row).  If anything other than "#NO MATCH" is in the cell, my goal is to have them turn green - haven't gotten that far because the first rule won't work.  Any ideas?

conditional formatting not working.PNG

conditional spreadsheet.PNG