Search results for query: *

Goal: If the date typed in B3 is older than 25 days, I would like to highlight the entire row in red, UNLESS M3 contains any value whatsoever. Any tips on how to do this? I have already created a column that gives "days old" using "=IF(ISBLANK(B3), "", TODAY()-$B3)" Any help is appreciated

This did not work. See: http://files.engineering.com/getfile.aspx?folder=e5853227-3c41-45f2-84f6-67cbb5555b82&file=EXCEL.jpg For a sample from the worksheet. I would like the formatting to be applied to instances where copy matches post date

If two cells have the same value. these are days of the week, match, then I want a third cell to turn red. What is the formula? The cells are F7 and H7 although this will be applied to a series of other cells. Please advise and thank you in advance!

I found an error on my side. This is exactly what I need. Thank you

I don't think this is quite what I am looking for. Column E contains the drop down lists, the options are listed in my OP. I want column G to automatically populate based on the value that is selected from the drop down list

This may just be a complicated IF THEN statement, please help. I already have a drop down list in place. How can I have whatever value in the drop down list populate a value in another cell? For example: "Left Early" I want to populate another cell with 0.50 "Called Off" - 1 "No Call No show"...

SOLVED: =IF(ISBLANK(D12),"",DATE(YEAR(D12)+1,MONTH(D12),DAY(D12))) Allows for a blank cell to produce a blank result. Any date in D12 will then be that date+1yr in the cell the formula is placed into. Thank you for your assistance.

Skip, I see what you are saying but =IF(ISBLANK(D12),"",D12) does not allow a date value to be entered into D12 and populate as a year later for another cell.

I have a formula to take a cell and add a year to it in another cell. (i.e. modified date and expiration date) In the expiration date field there is the formula: =DATE(YEAR(D12)+1,MONTH(D12),DAY(D12)) However, if the referenced cell (D12) is blank, then I get "12/31/1900" I just want the...

Error: Method not found: 'Void System.Net.Security.RemoteCertificateValidationCallback..actor(System. Object,InPtr)'. Any clue what this error means or points to?

In CCM - Select the DN you want to be forwarded, scroll down to "Call Forward and Call Pickup Settings". Find "Forward All" check the box and type the desired destination extension

SOLUTION: Any DNs on the phone must have an extension before adding more numbers. I was attempting to setup this phone with 6 blank DNs for future use. After the 2 DNs on the phone had extensions assigned to them "Add DN 3" became an available option

When I go into CCM (Cisco Call Manager) I can only add two DNs to this phone. The hardware allows for 6. I cannot copy it from another phone because we do not have another 7961 previously set up. When I select "Modify Button Items" I cannot see anywhere to add another DN ...

So I am very happy with my current router and due to some tasks I perform through work I cannot change it. Only problem with the router is that it does not have wireless. What is my best option for adding Wifi to my network? An access point? Or just another router?

I am using Acronis True Image Home (Version 10.0) Acronis is on an external hard drive attached to a Dell OptiPlex 760. For some reason the PC is not recognizing any SATA hard drives I connect. BIOS settings have both SATA connections turned on and SATA operation is ATA (as opposed to AHCI or...

I guess I did not word that properly. Yes I could do that. To better phrase my problem, I have a large amount of bricked phones. How do I ensure these bricked phones are no longer in CM? (Besides manually going through each one)

Hello, I sort my devices by extension and take a look at which phones have no extension associated with them. I am out of CCM Licenses so when I fix a broken phone I have to go into CM and delete another broken phone. There are 500+ phones in my environment. How can I see something like a...