Windows 10: Conditional formating

Discus and support Conditional formating in Microsoft Office and 365 to solve the problem; Hi all ,,,,again. I am using excel 2016 and have two rows of data thus,, WLWLWWLLLWL 76897665949 What I want is if the top cell is an L and the cell... Discussion in 'Microsoft Office and 365' started by donnylad, Jan 17, 2019.

  1. donnylad Win User

    Conditional formating


    Hi all ,,,,again.
    I am using excel 2016 and have two rows of data thus,,

    WLWLWWLLLWL
    76897665949
    What I want is if the top cell is an L and the cell immediately below it is more than 8, how do I do
    it to change the top cell to a red fill?. PLease.
    Len

    :)
     
    donnylad, Jan 17, 2019
    #1
  2. Fernandz Win User

    How To Format A Write Protected Flash Memory ?

    ¿You already tried this one?...

    Run CMD


    1. diskpart
    2. list disk

    Then in the 3º step, put the correct number of disk in the list for the usb flash (if it's listed in disk 3, then you'll have to write select disk 3).

    2. select disk #
    3. clean
    4. create partition primary
    5. select partition 1
    6. active
    7. format fs=fat32
    8. assign
    9. exit

    with that commands you will format the flash drive in fat32, if you have a large drive you can select also "format fs=ntfs" in step 7.

    good luck!
     
    Fernandz, Jan 17, 2019
    #2
  3. donnylad Win User
    excel conditional formating


    Thankyou very much for your reply Denis but, as I have already have formulas in the cells I have had to use conditional formatting (HOME, CONDITIONAL FORMATING, NEW RULE, "Use a formula to determine which cells to format") , and it is there where I put my formula.
    Well, while waiting for an answer I selected a cell that I had put my formula and looked about and in (MANAGE RULES) it shows my formula and it also says "Applies to". So I input =A$1:E$1 ,clicked on apply and there you are, it had done the whole row. So thankyou again and I think this will be helpful to others with the same problem.
    Len
     
    donnylad, Jan 17, 2019
    #3
  4. topgundcp Win User

    Conditional formating

    Cannot Format HD


    Need to initialize it as GPT disk type with HD > 2TB:
    From Admin command prompt:
    1. diskpart
    2. list disk =====> Take a note of disk # for the 4TB HD
    3. select disk # ====> From step 2
    4. clean
    5. exit
    Open Disk Management and initialize the disk as GPT, create simple then format.
     
    topgundcp, Jan 17, 2019
    #4
Thema:

Conditional formating

Loading...
  1. Conditional formating - Similar Threads - Conditional formating

  2. Microsoft Edge conditional access and single sign-on for iOS & Android

    in Windows 10 News
    Microsoft Edge conditional access and single sign-on for iOS & Android: Microsoft Enterprise Mobility + Security (EMS) is excited to deliver conditional access protection for Microsoft Edge on iOS and Android. This integration expands your management capabilities as you deploy Microsoft Edge for the best browsing experience across all endpoints...
  3. windows 10 terms and conditions

    in Windows 10 Updates and Activation
    windows 10 terms and conditions: hi here are the terms and conditions of windows 10: https://www.microsoft.com/en-us/Useterms/Retail/Windows/10/UseTerms_Retail_Windows_10_English.htm I need to know how given section (2 d iii) we have that it means (I was told) that as long as I have a separate license...
  4. Excel 365 - Conditional Formatting - disappearing Text / Lines.

    in Windows 10 Network and Sharing
    Excel 365 - Conditional Formatting - disappearing Text / Lines.: Just purchased office 365. Had 2007/2013 previous and no problems with the following; Conditional formatting - for turning text on / off and or lines on/off - based on conditions. If I scroll the mouse / display up or down or open and close a column or choose a drop down;...
  5. Task Scheduler - Idle Condition Not Honored

    in Windows 10 Support
    Task Scheduler - Idle Condition Not Honored: This should be pretty simple but really has me stumped. I have a scheduled task that is specified to only run if the computer is idle for 50 minutes. This works on Windows 7, but on Windows 10 it never honors the idle condition. It always runs immediately. This happens on...
  6. A race condition issue while ping, IPv6 AAAA DNS, Error message: could not find host.

    in Windows 10 Network and Sharing
    A race condition issue while ping, IPv6 AAAA DNS, Error message: could not find host.: Hi I'm finding that trying to ping even when using the -4 option is causing a problem because Windows simultaneously asks for both the IPv6 and IPv4 when trying to resolve a hostname with a local DNS. The parallel requests is causing a race condition where ping sometimes...
  7. ping -4 sends out an IPv6 AAAA DNS request causing a could not find host race condition error

    in Windows 10 Network and Sharing
    ping -4 sends out an IPv6 AAAA DNS request causing a could not find host race condition error: Hi I'm finding that trying to ping even when using the -4 option is causing a problem because Windows simultaneously asks for both the IPv6 and IPv4 when trying to resolve a hostname with a local DNS. The parallel requests is causing a race condition where ping sometimes...
  8. Win10 Error: User lockout condition after an @outlook.com Live account password is validly...

    in Windows Hello & Lockscreen
    Win10 Error: User lockout condition after an @outlook.com Live account password is validly...: Lost a day with this so thought I would write it up. Seems easy to recreate but I won't be doing this again. I don't work with virtual machines, I try to keep my friend's old laptop's running and this SSD drive upgrade and his forgotten password got me stuck and I believe...
  9. excel conditional formating

    in Microsoft Office and 365
    excel conditional formating: Hi to all,,, I am using excel 2016 and I have a 2 rows of data of which the top row consists of W or L and the row underneath consists of numbers that can be a number from 1 to 8. If the top cell is an L and the cell below is >6 I want the selected cell to be formatted with a...
  10. Excel Conditional formatting question.

    in Microsoft Office and 365
    Excel Conditional formatting question.: If I wanted to make a conditional formatting rule that would select all cells in a column [I2-I65] with a formula generated value less than 0.9 and greater than 1.1, ignoring all empty cells, what formula would I use? Thanks. 83089

Users found this page by searching for:

  1. elloohttps://www.microsoft.com/en-us/useterms/retail/windows/10/useterms_retail_windows_10_english.htm

    ,
  2. elloohttps://social.msdn.microsoft.com/Forums/en-US/home

    ,
  3. elloohttps://www.microsoft.com/en-us/

    ,
  4. elloohttps://support.microsoft.com/en-us,
  5. 5% 30%https://www.microsoft.com/en-us/useterms/retail/windows/10/useterms_retail_windows_10_english.htm,
  6. elloohttps://www.microsoft.com/en-us/useterms,
  7. icrosoft.comhttps://www.microsoft.com/en-us/useterms/retail/windows/10/useterms_retail_windows_10_english.htm,
  8. 5% 30%https://www.microsoft.com/en-us/useterms,
  9. elloohttps://www.reversefunding.com/,
  10. elloohttps://www.ign.com/,
  11. elloohttps://helloo.org/,
  12. elloohttps://support.office.com/en-us,
  13. elloohttps://www.cnet.com/logging-out/,
  14. 143 305*70https://www.maxrpmusa.com/?utm_source=aim-dsp&utm_medium=cpm&utm_campaign=remarketing,
  15. 143 305*70https://www.controlwithcable.org/choose/