Conditionally format entire worksheet
OR use in FORMULA IS
=ISNUMBER(FIND("M",A1))
or
=ISNUMBER(FIND("M",UPPER(A1))) if you want both m and M.
"Teethless mama" wrote:
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
|