Conditional formating

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
 
S

Sheeloo

Use the option FORMULA IS in Conditional Formatting and enter the formula
=COUNTIF(E9:Q9,"a")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting with dates 7
Mail Merge Directory Conditional Page Break 0
Dealing with the error: unable to filter on excel hc home school 0
Conditional Formatting assistance 7
conditional formating in adjacent cells 2
Conditional Formatting 5
Merging from an Excel file with graphics 1
Conditional formatting disappears when cell contents deleted 2

Top