Forum Discussion
Need help with this work project pleaseeeee
Hello, I have a spreadsheet with all my data in rows. Within the rows I have conditional formatting to turn a cell red if there is an error, along with a formula that adds "-NO MATCH" if there is an...
in G3 (assumed you run Excel >/= 2021 as you didn't mention):
=IF( SUM( ISERROR( B3:F3) + IF( NOT( ISERROR( B3:F3 ) ), B3:F3 = "-NO MATCH" ) ), "Yes", "No" )
Sorry that didn't help you