Macro to colour cells

[mad4darts]

Hi Im new here, so please be gentle!!

I have a spreadsheet that has various text in a column, eg:

OK
Yard
MTS
etc
etc

To colour each of these I know I can use conditional formatting, which is fine, but there's more than 3 I want coloured.

Can I do this using macro recorder, or do I have to use VBA? I'm not familiar with either.

There Excel version I have is 2000.

thanks in advance for any help

 

[kpark91]

You can jsut use conditional formatting by using the concept of "OR" operation

For example, in conditional formatting
= "OK" OR "Yard" OR "MTS"

 

[mad4darts]

I have more than 3 descriptions that I need to colour the background though, so conditional wouldn't work

 

[kpark91]

Could you elaborate more on in which columns you are checking the values.
and what values you are checking for?

 

[mad4darts]

I have the following descriptions:

OK
YARD
MTS
GOVAN
NOT AVAIL

in column C. What I want is, if the description is OK, colour it green. If the description is MTS, colour it Red etc.

Not sure if it can be done without VBA though?

 

[kpark91]

Yes it can.
You just have to make 2 rules in conditional formatting.

1) Select Column C
2) Conditional Formatting
3) Custom Formula (New Rule)
4) = "OK"
5) Colour Fill -> Green
6) Custom Formula (New Rule)
7) = "MTS"
8) Colour Fill -> Red

 

[mad4darts]

that's fine and I understand that, but what I'm saying is....I have more than 3 descriptions I want to colour, so CF is no use to me!