Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formating
Welcome, glad it helped.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "wildauk" wrote in message ... Brilliant, thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formating | Excel Discussion (Misc queries) | |||
conditional formating | Excel Worksheet Functions | |||
Conditional Formating | Excel Worksheet Functions | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Conditional Formating | Excel Worksheet Functions |