View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

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