Help me please, with a formula!

Hi everyone, i need help with the following please: 

Cell B16 contains a date (which is validated so it is a wednesday) 

If no data inputed in to cell B27 (9 days > then the date in cell B16) i 
want cell B27 to turn red. 

However if cell b16 contains no data then I want cell B27 to do nothing.

Hope that makes sense.

Many many thanks 
Dan 
0
Utf
2/11/2010 9:16:12 PM
excel.misc 78881 articles. 5 followers. Follow

0 Replies
570 Views

Similar Articles

[PageSpeed] 47

Reply:

Similar Artilces:

ROUNDED NUMBERS IN FORMULA'S
Can anybody help me to set up Excel so that it uses rounded numbers in formulas? I have got the cell formatted to 'show' the number rounded to two decimal places but the complete root number (shown in the formula bar), is used! Eg. 1.5642 (1.56 shown) x 4 = 6.2568 (6.25 shown) I want to multiply 1.56 x 4 = 6.24, without going into each individual cell and removing the unrequired numbers. I hope that somebody can help me - even if it is to tell me to stop trying because it's maybe not possible. I thank anybody in advance for any constructive response. bing1080 =round(A1...

Exchange 5.5 help required
I have a situation here at work : We are using exchange 5.5 on windows 2000 and outlook 2000 client. Several people in the organisation need to be able to view others mail boxes for legitimate business purposes, so we have permissions set up on the exchange to allow them to do so. I need to be able to see when one of the users is looking at anothers inbox, as i beleive this system is being abused for political gain. I have switched on the tracking into log files, but now i'm stuck. I am not sure if this really gives me what I am looking for. The Aplpication log is no help as it only...

help #26
Can anyone out there help me with setting up a graph for the following info. See bottom of page for example of what i am looking Cost Centre Received in Finance No Days 2010 May-04 29 2010 May-04 15 2010 May-04 21 2001 May-04 14 2026 June-04 34 2038 June-04 30 2010 May-04 17 2028 June-04 39 2010 Ma...

Help for formula.
Hi. I want to solve a linear of n X n equations system in Excel, where the solution can be derived as follow: Xn = ao Xn-1 = a1 * Xn Xn-2 = a2 * Xn-1 + a3 * Xn Xn-3 = a4* Xn-2 + a5 * Xn-1 + a6 * Xn e.g. The an coefficients (a0,a1,a2,….an) are all known. Lets simplify the above system using an example. Lets say that n=5 and: X5=7 X4=2*X5 X3=3*X4+2*X5 X2=1*X3+3*X4+4*X5 X1=1*x2+1*x3+1*x4+2*x5 (Then the solution is: X1=210, X2=126, X3=56, X4=14 and X5=7) Any idea how can I solve these n x n equations in general form in Excel? (I tried with sumproduct() but I stuck in coeff...

Help with DateValue function (part 2)
I was provided with the following formula courtesy of macropod and JE McGimpsey which works exactly as expected. The formula is:- =IF($A$4="spring",DATE(YEAR(TODAY())-1,12,31),IF($A$4="summer",DATE(YEAR(TODAY())-1,3,31), IF($A$4="autumn",DATE(YEAR(TODAY())-1,8,31),"ENTER CORRECT SESSION"))) The question I have is that as the TODAY function is used, will the field with the formula change on the turn of the year? What I mean is, if the formula is in L2 and the value of A4 is spring, then today L2 will be 31/12/06, however on the 01/01/2008, when the...

Need a help with e-store script
Could you please help me? (sorry if this is a bit off topic) I am not technically minded, but I would like to start an online store. What should I start with? Are there any pitfalls that I should be aware of? Thank you ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements Try this - http://www.ecommerce.com/?pg=products. very good impression! ----------------------------------...

IF FORMULA need help
Please, I am trying really hard to work this out, but still I couldn't come to result I want. This is the example (invoices - paid, not paid...) column A..................... column B...................... column C DUE DATE....................PAID ON........................COMMENT 10.11.05.....................07.11.05........................paid, on time 15.11.05.....................20.11.05........................paid, late 20.11.05...................(empty cell)......................not paid, late 04.12.05...................(empty cell)......................not paid, not late So, you...

HELP Please with Offline Address Lists
Using OL2003 with Exchange 2003.... I have created several address lists in Exchange SM under "All Contacts". I've added all of those to the list of address lists found in the Properties of the Default Offline Address List. However, using OL2003 offline it appears that I can only have 1 of them?!?!? When offline, I can see the Global Address List, but when I switch to another address book it gives a "no network" error. When back online in, in OL I go to Tools-->Send/Receive-->Download Address Book. It asks which one. If I switch to something other than the...

avg formula and blank cells
What is the proper way when using the AVG function with cells formatted as numbers, to fill a blank cell so it won't make the avg lower, but rather be ignored in the AVG function? Thanks! --Randy Starkey __________ Information from ESET NOD32 Antivirus, version of virus signature database 4080 (20090515) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com Excel ignores blanks cells when averaging. If you mean ignore cells uncertain a certain value. In Excel 2007, use AverageIf. In earlier versions you need to construct the formula using SumIf ...

problem with NdisReturnPackets ( ) please help me!
hello all: get BSOD on xp sp2. this code: //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// NDIS_STATUS PtReceive( IN NDIS_HANDLE ProtocolBindingContext, IN NDIS_HANDLE MacReceiveContext, IN PVOID HeaderBuffer, IN UINT HeaderBufferSize, IN PVOID LookAheadBuffer, IN UINT LookAheadBufferSize, IN UINT PacketSize ) { PADAPT pAdapt = (PADAPT)ProtocolBindi...

Date conversion, PLEASE HELP
I am importing data from an OBDC datasource. One of the fields is a date field that imports in this format "20040818", as a number. I am trying to convert this value to a date format and have had no luck. If anyone can provide assistance, I am grateful... MyDate = DateSerial(Left([ImportedDate], 4), Mid([ImportedDate], 5, 2), Right([ImportedDate], 2)) -- Ken Snell <MS ACCESS MVP> "shawn" <shawn.abbott@mrgasket.com> wrote in message news:8ac901c4854e$3aa483e0$a601280a@phx.gbl... > I am importing data from an OBDC datasource. One of the &g...

Gurus need your help on Centering AfxMessageBox using SetWindowsHookEx
Hi there, I have a (Dialogbox with a button) which I open from the Menu which is vertical shaped and docked at the left side. I click this button on the dialogbox and AfxMessagebox is flashed which is at the center of the dialogbox . In that way its flashing at the left side. I call a App's DisplayMessage function in order to show this messagebox. I though if I display this dialog from App , it may come at the center but that is not the case. I want this AfxMessageBox to be flashed at the center of the frame. I read few postings here. I used following code using SetWindowsHookEx. Somb...

help with "=(A3*A3)" command #2
Okay, what i was doing was pasting the values from a webpage. So opened up a new worksheet and hand typed the value into A3 and th formula now works -- happe ----------------------------------------------------------------------- happee's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1536 View this thread: http://www.excelforum.com/showthread.php?threadid=26987 ...

Indenting causes my text to disappear.. help!
Hi, Ok i've wrote a project that needed to be completed on 2 columns per page. Which i have done no problem. however, they told me now that i need to re format the columns so that there is 0.6cm spacing between the columns, and a left indent of -1cm and a right indent of -1cm. When i highligh all my text and do the indenting and the spacing it means that some of my text disappears.. if i go through each line on the left column, and press enter it reappears on the next line, however i dont know how to access my hidden words on the right hand column? PLEASE HELP. Is there...

Help with excel 2007 chart
Hey, this seems fairly simple but is stumping me. I have a table with static data that shows my budgetary costs per month for the last 2 years. The row labels in my table are the categories (mortgage, insurance, power, gas, phone, etc.) and the column labels are each month for 2007 and 2008. What I want to do is create a chart that will graph the data (line chart) for each category over the last two years. I would like to choose what category to display on the chart so they're not all on the chart at the same time. I have tried a Pivot Chart, but it's just not displaying the data corre...

Help with drop down boxes/menus
Can some assist me with adding a drop down menu to a cell ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements Look at VALIDATION under the DATA pull down menu Good Luck Mark Graesse mark_graesser@yahoo.com ntrain22, It's all detailed at this site http://www.contextures.com/xlDataVal01.html Dan E "ntrain22" <ntrain22.xrj4p@excelforum-nospam.com> wrote in me...

Access 2003 query help please
Hello, I am in need of some advice for a table create query. I have to work with a database that is imported using XML from an online database. Unfortunately the online database is a single (flat) table of membership data. I need to generate a mailing list from that data. The problem is that each record may contain one of two addresses for the mailing to a member. One is the organization address they work at the other is an optional mailing address. If the optional mailing address is present those fields must be used, otherwise the fields containing the organization address should be us...

PP2003 every image and embedded object turned into red cross, help
I have been working of a PP presentation (in Office 2003) for a number of days. Today when I opened the document all of the images and embedded excel worksheets have turned into boxes with red crosses on them. If I double click on the red crosses that I know are the embedded worksheets then the worksheet opens in Excel with all my data displayed correctly. This shows that the correct data is in the file. However when I click outside the worksheet (i.e. back on the slide) the worksheet is shown in huge scale (i.e. just a few cells is as big as the slide). I then reduce the size o...

Outlook Mail pre-view window bigger..Calendar disappeared..Help
I'm new to Microsoft outlook and like it very much! On my outlook mail home screen I had four columns.. column 3 had a mail preview window and column 4 had a small one-month calendar. I thought I was hitting a right arrow on the calendar to change my calendar from August to September but instead my calendar disappeared and my mail preview window got bigger to use the space vacated by my calendar. Yikes! How do I get the calendar back? Outlook 2007? The right pane is called the To-Do Bar. To make it bigger again simply press the "<<" sign at the top of it. Other wa...

formula support needed
i have created a workbook that consist of 13 worksheets, (12 months and 1 total sheet) to help keep track of employee absent days. I am using alpha characters (ie V = Vacation, S = Sick) to determine the missed day. I would like for my workbook to add up each "V" taken and calcualted on my "total" sheet. HELP???? my email is "johnny@btxexpress.com" Hi Johnny: A pivot table can help you. Let's say you have two columns on a worksheet. Column A has either "V" or "S" in each cell. Column B has hours in each cell. Put a label on to...

SRS Data connector remote instance setup not working HELP urgent
Hi guys, Ive been on this for a week now its really annoying. If I do setup of srs just by double clickign setup file and pointing to named instance setup passes but srs doesnt work, I imagine it tries the default instance SRS. If I use the XML file to configure it, it doesnt pass the reporting service test, even though , I paste the url from the XML in a browser and see all the crm reporting db entries. Heres a paste of my XML file.. Please help! crmsetup> <srsdataconnector> <configdbserver>com-sharepointa\crmsql</configdbserver> <autoupdateconfigdb>...

Money 2003: help - how can I add trended items back into the cashflow analysis
I deleted some trended items from my cashflow analysis by accident on mny 2003, Is there any way of getting them back in there??? thanks in advance. Click on the 'customise cash flow' option which is either on the left hand side of the cash flow display, or right clicking on the chart. To put it back, you need to select an option in there. -- Glyn Simpson, Microsoft MVP - Money Check http://support.microsoft.com/default.aspx?scid=fh;EN-GB;mny for UK tips and fixes for MS Money. To send Microsoft your wishes or suggestions, use http://register.microsoft.com/mswish/suggestion.asp or...

please can you tell me how to use the "if" function (new user)
i am trying to teach myself Excel plaese can you tell me good tutorial and i would like to know how to use the " if " function maxwell wrote: > i am trying to teach myself Excel plaese can you tell me good tutorial and i > would like to know how to use the " if " function Just open Help in Excel and type in IF statement. Microsoft has an Excel helper also. Good for the basics. http://office.microsoft.com/en-us/training/CR061831141033.aspx gls858 "maxwell" wrote: > i am trying to teach myself Excel plaese can you tell > me good tutorial and i woul...

Multiple formulas in subtotal
Hi, all. This is difficult for me to explain, but I'm trying to use the sum function for one column in my subtotal but I would like two other columns to show me what exists for that section. Sales_Code PeopleSoftID SalesRep Sales 00014 117895 BAKKER 72.67 00014 117895 BAKKER 533.88 I would like the subtotal to look like: Sales_Code PeopleSoftID SalesRep Sales 00014 117895 BAKKER Total 606.55 When I use the sum function at change in SalesRep, I get blank cells...

Wild card formula
Okay, I'll try my best to explain this one... I have several customers with the same name but with different endings. For example: ABC (Japan) ABC Elec (USA) ABC Corp (Korea) On a query spreadsheet I set up, all one has to do is type in the customers name and it will tally units by product, time period and application. To do this my array formula is: =SUM(IF((Sheet1!$A$4:$A$1793=D$1)*(Sheet1!$H$4:$H$1793=$C3) *(Sheet1!$B$4:$B$1793=$A3),Sheet1!$M$4:$M$1793)) Of the three conditions required, the third one is my problem ($A3 refers to the customer name that one is prompted to ty...