Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. robertbarrett

    Excel/Conditional Formatting

    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
  2. robertbarrett

    Formula/Conditional Formatting Help

    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!
  3. robertbarrett

    Excel Formula needed

    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"...
  4. robertbarrett

    Excel - Ignore blank cells

    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...
  5. robertbarrett

    Error message

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

    Cisco 7961 - Adding more than 2 DNs

    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 ...
  7. robertbarrett

    Adding Wifi to a small home network

    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?
  8. robertbarrett

    Using Acronis on Dell Optiplex 760

    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...
  9. robertbarrett

    Finding unused phones in CM

    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...

Part and Inventory Search

Back
Top