Can You Translate This Function Into Excel Format?
 

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

Can you rephrase your code in words?
I'm not into PHP but I can VB


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

for if statement, put like this in your cells D2
=IF(C2="",TODAY()-B2,C2-B2)

and for your conditional format

criteria1:
formula=AND(D214,E2="Yes")
set your pattern color to blue

criteria2:
value greater than 14
set your color to red


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

Cheers for the help guys. I have got it working now. I changed it around
a bit and now use...

Code:
--------------------
=($C2<"") - Fill Green
=($E2="Yes") - Fill Blue
=($D214) - Fill Red
--------------------


+-------------------------------------------------------------------+
|Filename: ExcelMIDLog.GIF |
|Download: http://www.excelforum.com/attachment.php?postid=3753 |
+-------------------------------------------------------------------+

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