conditional fomatting

I am trying to set up conditional formating to colour the cell if for example L10 < E10, but only if data exists in E10 for the entire column(s) the perfect world would be if L10 < E10 only if G10 exists, but that might just be pushing a bit too much

Conditional Formatting cells for text Hello,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I am new to this so i apologize if this is already posted... What i am looking to do is conditional format a column to look for several things. <o:p></o:p>...

Hi, I have a range of cells that are the results of an analysis and a second range of cells (same dimensions) stating whether or not the corresponding cells are statistically significant. I would like to highlight the cells in the first range based on whether the corresponding cell in the other...

I have tried using conditional formating and it does not seem to do the trick. What Im needing is Example: If A1 contains the same data is A2 then fill the cells yellow. In conditional formatting when i do this the cells turn yellow, I need them to wait till there is data in them before they...

I have a sata set and want to highlight the row that contains the highest percentage. I have used this formula =IF(Q7=LARGE(Q$7:Q$26,1),1,0) and it is giving me the curious result shown below where the sales value is not highlighted. Any ideas as to how I can correct this? I am using Excel...

I am trying to figure-out how to set up conditional formatting of dates in a column (e.g. Date Submitted) and have these dates, and/or cell, change color as time progresses. I have Excel 2007. For instance I have an application submitted on 11/20/2011 in a cell. I would like to have the date...

Please bear with me while I try to explain this.. I have a workbook which information is fed in through the frontpage. On running the MACRO the information is then sent to numerous other pages for working out costs, this then clears the boxes ready for the next batch of information...

Can I have a range of cells (B9:G9) highlight if any cell within that range is being clicked on or typed into? I would want to apply this to rows 9:67. Thanks, Andrew