I can write functions in PHP & MySQL, but can't get my headd around
another language for Excel.

I have a spreadsheet with 2 columns for dates (B & C), a duration
column (D) and a Yes or No column (E). We fill column B with the date a
car arrives at our workshop, C with the date it leaves, D with the
duration of time we had it and E if it has been added to the insurance
database [if it is with us more than 14 days].

I need to work out the duration column with the following style of
function...

Code:
--------------------
if $C2="" then ($D2="todays date"-$B2) else ($D2=$C2-$B2)
--------------------

I also need a function to perfom the following conditional format...

Code:
--------------------
if $D214
if $E2="Yes" - Highlight row in BLUE
else - Highlight row in RED
--------------------

Any help with this would be really grateful
Ian


--
iwgunter
------------------------------------------------------------------------
iwgunter's Profile: http://www.excelforum.com/member.php...o&userid=15441
View this thread: http://www.excelforum.com/showthread...hreadid=399523