Assuming you're looking for a letter "e"

Select your range

Conditional Formatting:

=COUNTIF(A1,"*e*")



"JDesmarais" wrote:

I want to format the worksheet to look in every cell for a letter and if that
letter is present, color the background a color. I cannot figure out how to
write the formula to search the entire worksheet without turning the entire
worksheet the color.

Example, everytime a cell's entry is M color the background green