Need help with "If statements" and conditional formatting PLEASE.

[realcutie1]

<INS style="BORDER-BOTTOM: medium none; POSITION: relative; BORDER-LEFT: medium none; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-LEFT: 0px; WIDTH: 234px; PADDING-RIGHT: 0px; DISPLAY: inline-table; HEIGHT: 60px; VISIBILITY: visible; BORDER-TOP: medium none; BORDER-RIGHT: medium none; PADDING-TOP: 0px"><INS style="BORDER-BOTTOM: medium none; POSITION: relative; BORDER-LEFT: medium none; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-LEFT: 0px; WIDTH: 234px; PADDING-RIGHT: 0px; DISPLAY: block; HEIGHT: 60px; VISIBILITY: visible; BORDER-TOP: medium none; BORDER-RIGHT: medium none; PADDING-TOP: 0px" id=aswift_0_anchor>******** style="POSITION: absolute; TOP: 0px; LEFT: 0px" id=aswift_0 vspace=0 ******="var i=this.id,s=window.google_iframe_oncopy,H=s&&s.handlers,h=H&&H,w=this.contentWindow,d;try{d=w.document}catch(e){}if(h&&d&&(!d.body||!d.body.firstChild)){if(h.call){setTimeout(h,0)}else if(h.match){w.location.replace(h)}}" height=60 marginHeight=0 frameBorder=0 width=234 allowTransparency name=aswift_0 marginWidth=0 scrolling=no hspace=0>*********></INS></INS>

Hello,
I am in logistics and I can't seem to figure out this formula in excel.
So, I have Actual Arrival times of trucks in Column E which is inputed by one of my employees. I have set up column F to display a "O" if the time is in E column is less than or equal to time in C column. It will display an "X" if it is greater than that time. I also did conditional formatting so that if it displays a "O", the cell is green and if it displays and "X", the cell is red. Only problem is that I dont want anything in the cell if nothing is input into column E. I want it to remain blank until something is entered.

The formula I had was =IF(OR(E4<C4,E4=C4),"O","X")<C4,E4=C4),"O","X")

Column F is Green with a "O" in it if column E is blank.​

<C4,E4=C4),"O","X")
​

</SPAN>	Stage time</SPAN>	Window time</SPAN>	Gate Arrival</SPAN>	ARRIVAL STATUS</SPAN>	Gate Departure</SPAN>	DEPARTURE STATUS</SPAN>
DAY SHIFT</SPAN>		In</SPAN>	Out</SPAN>
TMMC CWDO - 03</SPAN>	0030 - 0130</SPAN>	500</SPAN>	600</SPAN>		O		O
TMMI IDLW - 02</SPAN>	0030 - 0130</SPAN>	500</SPAN>	600</SPAN>		O		O
TMMK KIPL - 02</SPAN>	0030 - 0130</SPAN>	600</SPAN>	700</SPAN>		O		O
SIA UDG - 01</SPAN>	0700 - 0800</SPAN>	800</SPAN>	900</SPAN>		O		O
TMMC CWDO - 04</SPAN>	0800 - 0900</SPAN>	900</SPAN>	100</SPAN>		O		O
TMMC CWDO - 05</SPAN>	0900 - 1000</SPAN>	1045</SPAN>	1145</SPAN>		O		O
TMMI IDAF - 01</SPAN>	1230 - 1300</SPAN>	1300</SPAN>	1320</SPAN>		O		O
TMMI IDLW - 03</SPAN>	1200 - 1300</SPAN>	1300</SPAN>	1400</SPAN>		O		O

<TBODY>
</TBODY>

​

 

[S.H.A.D.O.]

Hi realcutie1,

I don't know what has happened but your post seems to have overlapped text within it and is making it unreadable!!!
Perhaps you still have time to edit it.

 

[Michael M]

Duplicate

http://www.mrexcel.com/forum/excel-...ted-if-statements-conditional-formatting.html