Previous Topic Next Topic

Another Conditional Excel Help Req.

Closed
meddel - Dec 1, 2008 at 01:17 PM
sarbel.vilo Posts 233 Registration date Tuesday November 18, 2008 Status Member Last seen August 1, 2010 - Dec 2, 2008 at 05:13 AM
Hello,

I am wondering if could get some help with an excel VB macro.

What I'd like it to do is this: Columns E, G, I, K, M, O, Q, R, S, U, W & X-AI all contain dates in yy-mm-dd format.
I would like the macro upon loading the Master list to run a check on all the dated columns to and if the current date equals the month and year listed in the column then the cell be indicated in red. I am not sure if this matters but the dates in the columns are also hyperlinked off to other documents.

Any help would be deeply appreciated.

RG
Related:

1 response

Answer 1 / 1
sarbel.vilo Posts 233 Registration date Tuesday November 18, 2008 Status Member Last seen August 1, 2010 31
Dec 2, 2008 at 05:13 AM
I think you have to do it manually...

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

Hello,

I have got dates typed in the format following 01.08.98 and I want to change it to 01/08/1998 format. I tried applying the format we have in excel format cell date format but nothing is happening.

Please help me on this.

11 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

Hello,

I want a cell to change color if another cell contains the words "first aid". The text comes down from a drop down list and could read "First Aid" or "sleepover/first aid".

If the cell has "first aid" in it, I want the other cell to change color. I can get it to work if using formula f13=first aid but it won't change color if the cell says sleepover/first aid?

Can anyone help?

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

Hello,

I have random text in cell C6 that I would like to highlight green if cell N6 has 'yes', red if cell N6 has 'no', and grey out if cell N6 has 'n/a'. Any suggestions for which formula to use?

Any help would be greatly appreciated!

1 response
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

Hello,
hi sir/madam...i am doing some work with the students result in excel...but I faced a problem..it is simple but I havn't got dat in my mind...i have students total marks.now I wanna get the 1st 2nd 3rd...so on position of student leads from highest to lower one...

regards
hardy

6 responses