Excel question - conditional format

Dear Aquarelle,

I am relativley new at VBA - I can write very very basic code & I am trying to help a co-worker to make life a bit easier for her.
She has a spreadsheet with two colums of data - one is dates/times & the next one is an advertising code.
I initaly set up conditional formating for her but she often has more than three diffrent advrtsier codes.
So i figured we needed a macro that could do lots of diffrent advrtiser codes.
I have been trawling the internet for days trying to find a code that would help me & yours is the only one that comes close to doing what i need to do. yet not quite i have played around with yours & tried to modify it to what i want to do, but i keep getting syntax errors & compile errors.

I figure I am going wrong around the Dim area but not sure.

basically what i want to do is:

search through collum B & if it finds a certian advrtiser code it changes the font of that row to Red (for example).
I want to be able to have it search for as many advertiser codes as possible & change them all to diffrent colours.

Do you have any suggestions that may be able to help me?
I would be eternaly gratefull!

Kindest Rebecca

Hello,

I have an excel file with a list of 50 suppliers in col A, in col B is a deadline date they have to submit their report by.
In col C is the supplier email address.
Can you please advise me on how to set up macro so when we approach the deadline date, a email is sent to
the supplier to remind them to submit their report asap.
I am new to macros, can you please HELP!

Thanks a lot aquarelle!

Now I want to extend my question based on your script.

What if that value that I want to based on if coming from a list range and I've already format that range accordingly.

Meaning that, let's say I have these 3 list of values (CODE):
AIR (blue font, yellow background)
API (red font, rose background)
AST (black font, orange background)

And my target is to automatic color each row (within a range - not the entire row) which have 4 columns - date, subject, remark and CODE (same as above).

This is the sample file - http://www.speedyshare.com/930276611.html

Can you please help me.

Your help is so much appreciated.

Thank you.

Sub auto_open()
DerCell = Selection.Range("A2").End(xlDown).Address
Set MyPlage = Selection.Range("A2:" & DerCell)
Dim MyDate As Date
    MyDate = Now + 7
    
    For Each Cell In MyPlage
        If Cell.Value = [D10] Then
            Cell.EntireRow.Font.ColorIndex = [D10].Font.ColorIndex
            Cell.EntireRow.Interior.ColorIndex = [D10].Interior.ColorIndex
        End If
        If Cell.Value = [D11] Then
            Cell.EntireRow.Font.ColorIndex = [D11].Font.ColorIndex
            Cell.EntireRow.Interior.ColorIndex = [D11].Interior.ColorIndex
        End If
        If Cell.Value = [D12] Then
            Cell.EntireRow.Font.ColorIndex = [D12].Font.ColorIndex
            Cell.EntireRow.Interior.ColorIndex = [D12].Interior.ColorIndex
        End If
        
    Next
End Sub

hi,
I was looking for a format of the attendance sheet where a workers time in or late or absentism is supposed to be entered
i have tried conditional formatting for the colour change
but there is some problem there are not more than three options available in these case
Other than this when i use the function of time in =IF(ISBLANK(J13)," ",IF(J13>10:30,"Late","Present"))
i dont get an option to mark "absent"
CAn you elp me in this?
Thankyou in advance