conditional formating

W

wildauk

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.
 
M

Max

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
 
W

wildauk

Brilliant, thank you.

Max said:
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
Click to expand...
 
Top