Hi Frank,

No not working at all. Enter data and no area changes colour.

Any other ideas? Or does it seem kinda impossible?
Rgds
Baz

"Frank Kabel" wrote:

Hi
try
=SUM(COUNTIF($C$12:$U$285,{"a","s"}))

--
Regards
Frank Kabel
Frankfurt, Germany

"Baz masterson" <Baz schrieb im
Newsbeitrag ...
thanx frank,

if it was a selection instead of individual cell for example:
$C$12:$U$285

could I change the formula to match?
Thanx again for your help
Baz

"Frank Kabel" wrote:

Hi
in the conditional format dialog choose 'formula' and enter
=OR(A1="s",A1="a")

if A1 is your selected cell

--
Regards
Frank Kabel
Frankfurt, Germany

"Baz Masterson" <Baz schrieb
im
Newsbeitrag
...
Hi Everyone,
I am changing a spreadsheet that hopefully when either for
example a
or s is
entered in a cell the cell will go red.
I already have other conditions in the spreadsheet for other
formats.
Does
anyone know if this is possible?
If it is possible can you please explain a little more than usual
as
I've
only being "formatting" properly for around 2 months.

Any info greatly appreciated.
Baz