I currently have an excel file that has data in either column E, or F, or both. The data set changes in length, so there might be 3 rows of data or 3000 rows of data. I have figured out how to select all the cells that should contain data.

Although I’m not sure how I can get an error message if there are two empty cells in one row, within the range I have already selected. E.g. I want an error message to appear if e45 and f45 both don’t contain data. Although I don’t want an error message to appear if e45 had data but f45 does not.

I tried to use chat gpt to help out but I couldn’t get it to work.