Hey There, 

I have this basic image field "Status Detail Color" that will display an image based on my case "Status Detail". It is working great, but there are two date fields that also determine what this image should be. I need the formula below to show a different image

IF "Date Scheduled" and "Date Re-schedled" are blank

and a different image if "Date Scheudled" or "Date Re-scheduled" are not blank

Any suggestions? 

IMAGE( 
CASE( Status_Detail__c, 
"Waiting Estimate Tech","/servlet/servlet.FileDownload?file=01560000001Gmx8", 
"Waiting Tech", "/servlet/servlet.FileDownload?file=01560000001Gmzx", 
"Scheduled", "/servlet/servlet.FileDownload?file=01560000001GmxD", 
"Waiting Part", "/servlet/servlet.FileDownload?file=01560000001Gmx3", 
"Waiting Client", "/servlet/servlet.FileDownload?file=01560000001Gmx3", 
"System Down", "/servlet/servlet.FileDownload?file=01560000001Gmwy", "Bid Due Waiting Office","/servlet/servlet.FileDownload?file=01560000001GmxI", 
"Waiting Estimate Office", "/servlet/servlet.FileDownload?file=01560000001GmxI", 
"Bid Inspection Assignment", "/servlet/servlet.FileDownload?file=01560000001GmxN", 
"Connect Tech & Customer", "/servlet/servlet.FileDownload?file=01560000001Gmx8", 
""),"Pending")

I have a custom field in cases that is for "date scheduled" Is there any way to make the Date scheduled turn to the color red if the date is today or earlier? I assume that there is a function that I can assign to the "date scheduled" field do this? Can anyone help me out with this?

Thanks!  

I have a custom field in cases that is for "date scheduled" Is there any way to make the Date scheduled turn to the color red if the date is today or earlier? I assume that there is a function that I can assign to the "date scheduled" field do this? Can anyone help me out with this?

Thanks!