changing cells based on dates

[mark007]

Ah ok. In that case you need to look at the worksheet_change evnt. You've actually made up and event. The events available for the worksheet object can be found by seleceting the worksheet in the top left dropdown of the codewindow. The evnts will then be listed in the top right drop down.

On selecting the change event the stub will be created for you.

You could then use soemthing like:

if target.column=11 then 'i.e. column K
    if range("H" & target.row)<>"" then 'column H isn't blank
        if target.value<range("H" & target.row).value then msgbox "Should be a value greater than column H"
   end if
end if

and similar for column N.