Conditional formating

  • Thread starter Thread starter Afia
  • Start date Start date
A

Afia

I wonder if anyone can help me please

I'm trying to set up conditional formatting for a cell based on data in
range of cells

for example: cell D9 should turn red if E9:Q9 contains letter a

I have been trying using find but no luck so far.
thanks
 
Use the option FORMULA IS in Conditional Formatting and enter the formula
=COUNTIF(E9:Q9,"a")
 
Back
Top