Excel VBA Change text colour depending on another cell's content

I have absolutely no experience in VBA;

I am using Excel 2002 and have a spreadsheet comprising columns A – BI and rows 1-900

Entries in column O can be C, N, RC, RN

I have been trying to write a code so that –

If Columns O = C and J is a date in the future, then Column C will automatically be populated with “CW” and the whole of the row will be in dark green text

If Columns O = “C” and J is today or a date in the past, then Column C will automatically be populated with “C” and the whole of the row will be in red text

If Columns O = “N” and P is blank, then Column C will automatically be populated with “W” and the whole of the row will be in dark blue text

If Columns O = “N” and P has a date in it, then Column C will automatically be populated with “E” and the whole of the row will be in black text

If Columns O = “RC” or “RN” and L is blank, then Column C will automatically be populated with “W” and the whole of the row will be in dark blue text

If Columns O = “RC” and L has a date in it, then Column C will automatically be populated with “C” and the whole of the row will be in red text

If Columns O = “RN” and L has a date in it, then Column C will automatically be populated with “E” and the whole of the row will be in black text

Any other entries should default to black text

All of the above to be non-case sensitive.

I’ve managed, almost, to get this to work using an IFAND function and conditional formatting but would rather use VBA because this would prevent any other users from meddling with the functionality.

Lastly can anyone suggest a good site for gaining an understanding of how to write VBA procedures, one that will explain things as if I am a simpleton and use words of not more than 2 syllables

Appreciate any suggestions

Leith, Thanks, I haven't had a chance to try this on Excel2002, but I have on 2003, unfortunately it doesn't work. I noticed a spelling mistake on your last line but correcting it has made no difference. The macro runs but doesn't update column c

Any suggestions, Thanks, Jell

Hi Jell

I think you just need to correct this bit of the code

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

so that column O is evaluated

also to update Column C you need to add the line

Please Login or Register  to view this content.