Conditional Formating Help

Hi 

I wonder if anyone could help me, I am after code for the following.

cell e6 = Keys Sent 
Column f6 = Keys due 
Column g6 = Keys received 

What I want the script to do is if there is no value in g6 and todays date 
is greater then the date stated in F6, then the cell turns red (prompt to 
inform me that keys are late).

Many thanks 
Dan 
0
Utf
2/8/2010 9:40:01 AM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
1275 Views

Similar Articles

[PageSpeed] 33

Use a CF formula of

=AND(G6="",TODAY()>F6)

HTH

Bob

"housinglad" <housinglad@discussions.microsoft.com> wrote in message 
news:A5887369-33DA-489A-BEC9-8173707313C6@microsoft.com...
> Hi
>
> I wonder if anyone could help me, I am after code for the following.
>
> cell e6 = Keys Sent
> Column f6 = Keys due
> Column g6 = Keys received
>
> What I want the script to do is if there is no value in g6 and todays date
> is greater then the date stated in F6, then the cell turns red (prompt to
> inform me that keys are late).
>
> Many thanks
> Dan 


0
Bob
2/8/2010 9:58:28 AM
Reply:

Similar Artilces:

identity removal help!
My son added a password to an identity for an email account. He doesn't remember the password. Any way to remove the indentity in outlook express Hi, JC - This is a group to support Outlook from the Office group of programs. Outlook Express is a part of Internet Explorer and is a quite different program, despite its similar name.. You will probably get a faster and more expert answer if you post this to an Outlook Express news group. Try posting in one of these newsgroups: microsoft.public.windows.inetexplorer.ie5.outlookexpress for OE 5.x microsoft.public.windows.inetexplorer.ie55....

Today Conditional Format
I have a column which calculated a date based on 3 working days from a date input into a diff column. What I want to do I have the calculated date appear bold if that date has passed based on the current date. For example if I input 01/08/11 the next column calculates 04/08/11 (3 working days). I want the caluclated date to appear bold when I open the spreadsheet on the 05/08/11 ro show the calculated date has passed. I can use conditional formatting but can't get the syntax right Regards Andy Win XP Pro Office 2010 Andy Roberts presented the following explanation : > I ha...

SelectNodes starts-with XPath help
I have the following XML: <folder name="global"> <folder name="_images"> <file name="creative_apply_txt.jpg" /> <file name="creative_culture_txt.jpg" /> <file name="push_btn_submit.gif" /> </folder> <folder name="en"> <folder name="_images"> <file name="creative_apply_txt.jpg" /> <file name="creative_home_txt.jpg" /> <file name="header_email_notice.gif" /> </folder> </folder> </folder> A...

Two Condition Vlookup?
I am currently trying to create a function that searches through an array for two exact column values which allows me to retrieve a third column value. For example: Type of Fruit Date Packaged Amount of Fruit Apples June 100 Oranges June 50 Apples July 75 Grapes July 50 In this example, I would be looking to retrieve the Amount of Fruit (Apples) that was packaged in July. I would be putt...

Can't format numbers for France in Excel 2003
I'm using the US version of Excel 2003, but need to format costs, etc., for a project in the French euro format (e.g., I need 2050.45 euros to display as 2 050,45). That currency format isn't offered in my dialog box, and if I make a custom number format that will display correctly, it doesn't operate as a number. Any suggestions? On Wed, 10 Oct 2007 08:51:03 -0700, Mary Fran <MaryFran@discussions.microsoft.com> wrote: >I'm using the US version of Excel 2003, but need to format costs, etc., for a >project in the French euro format (e.g., I need 2050.45 euros...

Printing Help
I know there should be an easy way to do this, but I have yet to figure it out. I have a 183 page report on school districts. I want to print all the information for one school district per page (or possibly two because a few of the larger districts might take up two pages.) On the report, I have one district per page or two and I could just print the whole thing but I don't want to. Is there a way to print a certain district? I don't want to just print page 42 and wonder what district that is. I want to print, let's say Spring School District, and only that page prints. Th...

help 04-20-10
since yesterday when ever i try and open an icon on my desk top this message comes up windows cannot access the specified file, pathway you may not have permission to access it? what does this mean and how do i fix it???? Also about a week ago when i was on the internet these system messages kept coming up saying my computer was in trouble and peple were trying to access my personal information and i needed to upgrage my spyware. i couldnt go into any programes except the windows security site and then i had to buy the 6 month protection to access anything on my computer. now ...

Help with an IF statement please...
Hello all... I have a column with these values (A+, A, A-, B+, B.....) and I am trying to assign numerical values to each grade I thought I had the formula down but I keep getting error messages... can you please tell me what I did wrong... Here is what I tried to enter... =if((if(D143="A+","100",IF(D143="A","95",IF(D143="A-","90",IF(D143="B +","89",IF(D143="B","85",IF(D143="B-","80",IF(D143="C +","79",IF(D143="C","75",IF(...

Query condition by date range
I'm trying to create a query to base a report from. I need it to return records within a date range that needs to be specified, as in specifying the beginning date and having the current date as the end date. A field is included in the query that has listed dates in the format mm/dd/yyyy. How would I write the criteria? I have part of it ready - [Please enter starting date:] . I know that's how you get the little question window. On Tue, 4 Dec 2007 14:51:00 -0800, silva wrote: > I'm trying to create a query to base a report from. I need it to return > records within a...

Help with Google Groups search
Forgive me for this off-topic request. But since it impairs my ability to help people with Excel questions, it might not be entirely inappropriate. I have not gotten constructive help through the Google Groups forums in the past for similar problems. If you can find the following article using Google Groups Advanced Search, please let me know how you did it field-by-field. Feel free to respond in email; send to joeu2004 "at" hotmail.com. The article is: Thread-Topic: conditional format cells by date From: <Simon@discussions.microsoft.com> Subject: conditio...

Need help with conditional formula (Excel 97)
Can anyone give me the correct syntax for the following formula: if A1 is blank, and B1 is more than zero, then display B1, otherwise display nothing (blank cell) Thank you JD =IF(AND(A1="",B1>0),B1,"") Success! -- met vriendelijke groetjes "Jake D" <JakeD@djhtend.com> schreef in bericht news:crkto4lv30u7uujv27ek8okr0us5t9oj10@4ax.com... > Can anyone give me the correct syntax for the following formula: > > if A1 is blank, and B1 is more than zero, then display B1, otherwise > display nothing (blank cell) > > Thank you > > ...

Format cells #7
I have Excel 2000, Win ME. Recently the pulldown command to format cells does not always respond - ie, no box appears, so I can't apply borders or control number format. The shortcut approach doesn't work either. I've tried Help..Detect and Repair but the fault remains. Any suggestions welcome. ...

Conditional formatting if condition of an if statement is true and a string value is displayed
Dear Experts: I got a nested 'IF'-Formula in an excel cell that returns nothing if the condition is false. I would like to conditionally format this cell with grey shading if the condition is true and a string value is displayed. How can this be achieved using excel conditional formating functionality ? Help is much appreciated. Thank you very much in advance. Regards, Andreas Let's say your doing this conditional formatting in cell K17. In conditional formatting (xl2003) choose the FormulaIs: option and enter: =$K$17<>"" choose your formatt...

Please Help....urgent
Hi, I am doing notes to exchange coexistence & am facing an issue. I have following Microsoft Document NotesDirandMailMigrat word by word & still the connector is not working at all. Issue : As soon as I start to sync directory using Notes connector, several events are logged in event viewer.. few of these are : -no Notes Session Open -Error {GRC:a}: The application failed to initialize. -Initializing Lotus Notes Interface -Failed to initialize the NOTES subsystem I am running Exchange 2003 SP2. The connector i have installed is from Exchange CD and SP2 reapplied after install. ...

Formatting worksheet
I have a workbook with three worksheets and one chartsheet in it. I have notes documenting various aspects of the four sheets. Some of those notes are on electronic post-it notes and others on scraps of paper. It seems to me that a convenient way to consolidate all of my documentation for the workbook would be to add another worksheet to it and put the information in it. What would be the best way to format the worksheet so that I could type information into it as if I were using a text editor? Leslie, Excel isn't really all that set up for text. I sometimes make narrow column...

Help needed on generating sequences
Hi all, in a excel sheet i want to generate the following sequences for some array of numbers let us say starting from 0 and going to N-1 bits, the sequence is from the Hamming Code. For clarity reasons i want to put a formula in excel that can show me which bit is to be checked as follows: Position 1: check 1 bit, skip 1 bit, check 1 bit, skip 1 bit, etc. (1,3,5,7,9,11,13,15,...) Position 2: check 2 bits, skip 2 bits, check 2 bits, skip 2 bits, etc. (2,3,6,7,10,11,14,15,...) Position 4: check 4 bits, skip 4 bits, etc. (4,5,6,7,12,13,14,15,20,21,22,23,...) Position 8: check 8 bits, skip 8 bit...

Outlook Certification Help
Do you need additional proof that you are an Outlook genius? Would you enjoy the respect and additional income that could come from being able to help everyone in your office on Microsoft Outlook? Get your Outlook Specialist certification and realize the benefits it can have. "Are You Certifiable (In Outlook, At Least)" is available at http://www.linkemup.us/areyoucertifiable.htm for only $18. It will go through each subject on the test and help you to prepare for this certification. If you do not plan to get certified but need a little extra help on using Outlook it is an excell...

Conditional Field in Queries
Is there a way to make a field in a query conditional so that it only displays the value if the value is equal to something specifically set? Thanks. Nick Nick.Korynski@gmail.com wrote: > Is there a way to make a field in a query conditional so that it only > displays the value if the value is equal to something specifically > set? Thanks. > > Nick Explain "the value is equal to something specifically set". -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com ...

XML validation error. Help required
XML validation error. Help required If anyone can help me, thankyou, thankyou... When I run this code code I get this error: The data at the root level is invalid. Line 1, position 39. I can't work out what the error is. Can you??? original code: Dim oRead As XmlTextReader Dim oValid As XmlValidatingReader Try oRead = New XmlTextReader("C:\custdoc.xml") oValid = New XmlValidatingReader(oRead) AddHandler oValid.ValidationEventHandler, New Schema.ValidationEventHandler(AddressOf ValidationError) oValid.Schemas.Add("newschema", "C:\custschema.xsd") oValid....

zip codes not being saved as text in CSV format
I need my file to be saved in CSV format (to import into another application). When I format the zip codes as Text or Special(zip code), they are correct in XLS format, but when I open the file in CSV format they switch back to general. Any solution? work around? Thanks so much for your help in advance!! Melissa Change the file extension to .txt and use the text import wizard to treat the column as text (last dialog) -- Regards, Tom Ogilvy "MelissaM" <MelissaM@discussions.microsoft.com> wrote in message news:B5A02627-810E-4234-8247-267D9B12FA29@microsoft.com... >...

format a column
I have a simple question to ask, I have a column in Excel is number like 142000, I want to format the whole column numbers without the two ending 0s, change 142000 to 1420, how can I do that? Thanks -- xcao ------------------------------------------------------------------------ xcao's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=14538 View this thread: http://www.excelforum.com/showthread.php?threadid=471821 Enter 100 in an empty cell and copy it. Then, select your range of numbers you want to change, Right Click and go to Paste Special, and select Div...

How do i use Conditional formatting for 3+ conditions ?
I have a text box in a report which highlights in colour current members in a list of past and present member names. I have six types of current members that I want to highlight, but with conditional formatting I can only use 3 conditions in the members [Type] field. I have tried [Type]="Full member" Or "Life member" but the "Or" doesn't work ! Is there a way to do this ? thanks .. Roger CF is limited to 3 contitions, but you can use OR in those expressions. If you set Condition1 to Expression, you can use: ([Type] = "Full member") Or (...

How to return a 12 hour time format without the AM in an Access query
The format function acts differently in a query and after hours of testing, messing, and cursing, I give up. How do you return 12 hour format without the AM or PM from an Access query. In my table, I've defined the Start Time and End Time to use "Medium Time" format and it works if and ONLY if you simple include the field in the query. However, if you use the field in a more complex statement, it returns leading zeros and trailing seconds. Here's what I've tried.... 'This didn't work because it returns trailing seconds and AM/PM. '2:00:00 PM...

Help with Conditional formatting with Dates
Hi there, I have a spreadsheet in which I have to monitor various dates which are in different columns (i.e. (1) Date Tender Released, (2) Date Company Selected, (3) Date Draft Contract Forwarded, (4) Date Contract Signed etc...). Would if be possible to Conditional Format and have diffirent ROWs highlighted for each individual Contracts (I have 300 running contracts running) every time a date is filled in these different columns: Initial Step (1) = Yellow (Call for Tender released) Step (2) = Blue (Company Selected) Step (3) = Brown (Contract under Process) Step (4) = Green (Contract Si...

Help Please
What i want to do is really simple. I have column B with 50 numbers. I want to set up column C so that in C2, if B2=B1 and then it returns a value or something like false. It really doesn't matter what it returns though. Then in C3, if B3=B2 OR B3=B1 then it returns the false value Then in C4, if B4=B3 OR B4=B2 OR B4=B1 then it returns the false. Then in C5, if B5=B4 OR B5=B3 OR B5=B2 OR B5=B1 then it returns the false value. Can anyone help please? I think I could do it with alot of logical statements, but you can only put 30 conditions into one cell. With a list of 50 numbers t...