Prev: In Excel 2007, how to send picture behind text
Next: Subtotal To Include Item Description On Subtotal Line
From: Afia on 23 Feb 2010 10:27
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
From: Sheeloo on 23 Feb 2010 10:49
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
 | 
Pages: 1
Prev: In Excel 2007, how to send picture behind text
Next: Subtotal To Include Item Description On Subtotal Line