Hello,
So the cell contains "MattressSofaCouch-1", I currently have the isnumber function to identify whether it is a mattress, sofa or couch but I need an adjustment to the formula to designate the "-1" as the color black.
Right now when I use the ISNUMBER formula and add the "-1", it pulls...