Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Conditional Formatting if cell is not empty

Status
Not open for further replies.

MrsNic

Instructor
Feb 6, 2005
44
GB
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.
 
You could use:
=(LEN(SUBSTITUTE(H$1,$C3,""))<>LEN(H$1))

combo
 
Thanks for this, it almost worked but gave me the required syntax to solve the problem. The way I solved it was

=IF(G3<>"",SEARCH(G$1,$C3),"")

Again many thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top