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
Bookmarks