conditional formating
 

Hi, what I would like to do is if I type in to a cell 12-12 or12-4 or 12-8 ,
the back ground of the cell would turn a diiferent colour ( say green) and in
the same cell if I type in 4-12 or 4-10 it would turn blue.
Can any one help?.

Thanks in advance.

conditional formating
 

This should get you going ..

Assume the CF to be applied on col A
First, think we need to format col A as Text (via Format Cells), to
"remove" Excel's inclination to convert your type of data entries (eg: 12-12,
4-10) as dates

Then select col A (A1 active), apply CF using
Condition 1, Formula is:
=OR(A1="12-12",A1="12-4",A1="12-8")
Format green fill

Condition 2, Formula is:
=OR(A1="4-12",A1="4-10")
Format blue fill OK out
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"wildauk" wrote:
Hi, what I would like to do is if I type in to a cell 12-12 or12-4 or 12-8 ,
the back ground of the cell would turn a diiferent colour ( say green) and in
the same cell if I type in 4-12 or 4-10 it would turn blue.
Can any one help?.

Thanks in advance.

conditional formating
 

Brilliant, thank you.

"Max" wrote:

This should get you going ..

Assume the CF to be applied on col A
First, think we need to format col A as Text (via Format Cells), to
"remove" Excel's inclination to convert your type of data entries (eg: 12-12,
4-10) as dates

Then select col A (A1 active), apply CF using
Condition 1, Formula is:
=OR(A1="12-12",A1="12-4",A1="12-8")
Format green fill

Condition 2, Formula is:
=OR(A1="4-12",A1="4-10")
Format blue fill OK out
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"wildauk" wrote:
Hi, what I would like to do is if I type in to a cell 12-12 or12-4 or 12-8 ,
the back ground of the cell would turn a diiferent colour ( say green) and in
the same cell if I type in 4-12 or 4-10 it would turn blue.
Can any one help?.

Thanks in advance.

conditional formating
 

Welcome, glad it helped.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"wildauk" wrote in message
...
Brilliant, thank you.