Excel Question - urgent!?

Question

Hi
Is it possible to assign a colour to a letter when doing an excel document, ie: im doing the new rotas for my new job role and i want to assign a colour to E for early and L for late, i dont want it as a background colour as this will take too long to do but want it for ever time i type E or L it will come up with those colours, please help guys, im need of prooving myself he he

Dannii X

Answer 1

Format -> Conditional Formatting

Set if the Cell is equal to "Early", click the format button, set to Green or whatever colour.

Then click Add below, and add one for late. Then copy and paste the cell to all you want it to have that behaviour.

Good luck

Answer 2

Go into Format, Conditional Formatting, then put the conditions in ie

Cell Value is equal to e (then click on format button and change the colour to red)

Everytime you then type in an e and return this will turn the letter e red.

Hope this makes sense.

Answer 3

Hmmm, I was going to say to go to the cell where u will be typing the word and right click on it, choose format and you should have an option there to choose ur font, size and color, etc., problem is, that would only allow u to choose one color for any text you put in that particular cell. Hopefully if there is a way to do that, someone here would know. If worse comes to worse you would just need to either make a seperate column for late or early and do the color coding in the cells.

Answer 4

Use Conditional Formatting on those cells that will contain the E and L characters. Set the condition 1 such that "if cell content = E font color is green". Set the condition 2 such that "if cell content = L font color is red". Now, anything other than E or L will stay in black.

Answer 5

You can use conditional formatting.
1) Select the cells that you want to assign a colour to
2) Click on "Format", then "Conditional Formatting"
3) Set "Condition 1" to "equal to"
4) Type in "E" in the next box
5) Click format
6) Select which colour you want the letter "E" to change to from the "colour" drop down menu
7) Press OK, then OK
8) Repeat for the letter "L"

Hope it works! x

Answer 6

Format the cells as Custom and use hh:mm this will take up no more space and will subtract correctly to give you 00:19 minutes which is correct, if you need it in hours, you need to change the formula to also divide the answer by 60. which equals 0.31

Answer 7

If your looking to only color the E and L then try this code
Right click on your sheet tab and select "view code"
paste this macro

Private Sub Worksheet_Change _
(ByVal Target As Excel.Range)
Application.EnableEvents = False
On Error Resume Next: x = Len(Target): For l = 1 To x
If UCase(Mid(Range(Target.Address), l, 1)) = "E" Then _
Range(Target.Address).Characters(Start:=l, Length:=1) _
.Font.ColorIndex = 3
If UCase(Mid(Range(Target.Address), l, 1)) = "L" Then _
Range(Target.Address).Characters(Start:=l, Length:=1) _
.Font.ColorIndex = 5
Next
Application.EnableEvents = True
End Sub

Answer 8

You should have a letter A with a coloured line beneath it, that one is font colour. If not got on to the toolbar options (the double arrow at the end of the toolbar and find it there, click on it and it will be on your toolbar.

Answer 9

You'll need to use Conditional formatting.

http://www.functionx.com/excel/Lesson07.htm

Answer 10

Miss G's given you the perfect answer - it's exactly what you need to do.