I have a spreadsheet that uses the following formula to search for some text contained in a colum in a particular range and highlight the cell where the the criteria is met.
=SEARCH(H$1,$C3)
To improve this I only want it to highlight the cell if it is not empty. I have played about with various options but can't get anything to work.
Any advice gratefully received.
=SEARCH(H$1,$C3)
To improve this I only want it to highlight the cell if it is not empty. I have played about with various options but can't get anything to work.
Any advice gratefully received.