ExcelBanter - Conditional formating

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Conditional formating (https://www.excelbanter.com/excel-discussion-misc-queries/257106-conditional-formating.html)

Afia

Conditional formating

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
--
Afia

Sheeloo

Conditional formating

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

"Afia" wrote:

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
--
Afia

All times are GMT +1. The time now is 06:41 AM.