How to apply Macro to a cell?

Hi

I've made a spreadsheet at home on Excel 2007 which has up to 5 Conditional Formatting rules per cell which works fine. The problem is when I save as 97-2003 version to send to work, the old version of Excel only supports 3 rules as you know, is there a way of applying 4 or 5 rules when specific text is populated in a cell on the old version of Excel?

Many thanks

There is no easy way:
Tricks: http://www.mcgimpsey.com/excel/conditional6.html
Add-ins (I can't reach it now): CFPlus you can read the text from Googles cache though.

Discussion forum link, http://www.mvps.org/dmcritchie/excel/condfmt.htm

The next step is paid add-ins, Excel 2007, or change to another spreadsheet supplier.

//Ola

Hi Olasa

Thanks for your reply. Had a look at the link on your post but don't know if I can make that work for me.

I basically want to add an A, P, L or an E to a cell which would colour the cell and text to match, somebody at work suggested I may be able use a macro which would be triggered by entering the letter in the cell, do you know if that's possible?

Many thanks

Greg

"I basically want to add an A, P, L or an E to a cell which would colour the cell and text to match"

You could have a look at this or make a post in the Programming forum.
VBA/Macros is not my strong side.

HTH
Ola


...A,P,L,E are 4 conditions. With one as default, 3 could be used.

Hi, thanks for your post, the link didn't work by the way but thanks.

I can record the macro but I don't know how to apply it to a cell rather than trigger it via a button. I'll post on the programming forum and see if anyone can help

Thanks again

Greg

link to cfplus now working they must have paid the bill
http://www.xldynamic.com/source/xld.....Download.html

Hi

Thanks for the link, looks like that would do the trick nicely however I don't have access to download and install add-ons in work

Never mind

Thanks

Greg

Hi

We have Excel 97-03 at work and I have a spreadsheet where I need to apply 5 conditional formatting rules to a cell but obviously can't on the old version of Excel.

I can't download any add ons as I don't have authority at work so I'm thinking I could run a macro if triggered by an entry in the cell.

I basically want to be able to enter a specific letter such as A, B or C etc into a cell which will trigger the macro and colour the cell and text to match.

How can I record a macro so it's triggered by entering a letter in a cell rather than applying a macro to a button?

Any help would be greatly appreciated

Thanks

Greg

Hi

Apologies firstly for cross posting, I wasn't aware of the implications however after reading the rules etc on VBA Noob's post I now have a better understanding so thank you.

I'm looking for a macro to apply to a range of cells which will be updated manually by entering either "A,P,L or E in a particular cell which will then change the colour of the cell and text to either green (A), orange (P), red (L), or yellow (E).

I know how to record the macro so that the cell and text change colour but I don't know how to trigger the macro by entering the letter in the cell.

Thanks in advance for any help

Greg

Hi

Many thanks for your reply and code, works great, I hadn't thought about using a drop down list but it works well.
My initial intention was just to key the letter into the cell, would it be difficult if I wanted to apply code so the colour is triggered by keying the letter?

Can you also advise how I'd change the code so that the text colour matches the cell colour so I end up with a cell which is one colour and I can't see the text letter?

Thanks again

Twaddy

Thank you VBA Noob, works a treat, just as I wanted.

I also need to apply something similar to a range of cells where the text is populated automatically from the following formula =IF(E742<1,"N/A",IF(E742<2,"RTW 1",IF(E742<3,"RTW 2",IF(E742<4,"RTW 3",IF(E742<99,"Well Being")))))

I need "RTW 1" to be green, "RTW 2" to be Yellow, "RTW 3" to be Orange and "Well Being" to be red.

I've tried amending the code you wrote however it isn't working, not sure if i'm doing something wrong or whether it's down to the text being populated from a formula.

Sorry to be a pain but could you advise please, struggling to get my head round it

Cheers

I've amend the code so it works for RTW 1, 2 and 3, changing the colour of the cell as required however "Well Being" isn't changing colour. Below is my amended code, would you mind looking over it and advise if there's something which would prevent "Well Being" changing the cell colour?

HTML Code: 

Thanks

Brilliant, works perfectly!

That's all I need for now on this post, thanks for all your help and advice

Cheers

Twaddy

Little bit neater and simpler isn't it, thanks.

Twaddy

I'll be honest, I didn't know IF statements were limited to 7 conditions. Someone at work wrote that formula, I'm only just getting to grips with Excel as you can tell

Cheers

Thanks for the links, think I'll try and keep it under 7!

Cheers