Windows 10: excel conditional formating

Discus and support excel conditional formating in Microsoft Office and 365 to solve the problem; 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... Discussion in 'Microsoft Office and 365' started by donnylad, Nov 28, 2018.

  1. donnylad Win User

    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 red fill.
    I can do it on just one cell with this formula: =AND(IF($a$1="L",1),IF($a$2>6,1)) which works just fine but I have a lot to do on 2 sheets which will take forever, can someone please tell me a formula that lets me select a full row to check the row below and only formats the cells that have L above and >6 below.

    Len

    :)
     
    donnylad, Nov 28, 2018
    #1

  2. 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.
     
    FuturDreamz, Nov 28, 2018
    #2
  3. format cells in excel

    Hi Coolrunnings63,

    It appears that we currently do not have the ability to undo formatting in the mobile version of Excel 2013. I believe this is a definite candidate for the

    Windows Phone Suggestion Box
    . The only exception is if you tap Undo in the ellipse menu (...) after adding the formatting.

    As a possible workaround, I'd suggest saving the file to your SkyDrive account, then logging into your free SkyDrive account using a web browser and use the free web-based Excel to remove the formatting.

    I hope this helps!

    David
     
    David Scammell, Nov 28, 2018
    #3
  4. Fernandz Win User

    excel conditional formating

    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, Nov 28, 2018
    #4
Thema:

excel conditional formating

Loading...
  1. excel conditional formating - Similar Threads - excel conditional formating

  2. excel

    in Windows 10 Software and Apps
    excel: In hospital bill i want to find ward charges but i don't know the formula https://answers.microsoft.com/en-us/windows/forum/all/excel/2504def0-9b7c-4ec7-a221-e59d629725d3
  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. Conditional formating

    in Microsoft Office and 365
    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 125425
  7. Excel

    in Windows 10 BSOD Crashes and Debugging
    Excel: When I save an open file from my QuickBooks software, I get message there may not be enough memory to do this and wants to save as a csv file. I have almost a Terabyte available. Not sure what to do. Mike...
  8. 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
  9. Excel not responding. Trying to format a column of phone numbers.

    in Microsoft Office and 365
    Excel not responding. Trying to format a column of phone numbers.: Excel 2010 I have a column of 22,000 phone numbers (and an additional column of fax numbers). I'm trying to convert the numbers from nine digits to nine digits with hyphens. I copied and renamed the original document. There are no protections. To be certain, I ran the...
  10. Small Window and Error Condition

    in Windows 10 Support
    Small Window and Error Condition: How to Run Windows 10 on Mac 100% FREE (Yosemite / El Capitan) [MEDIA] I downloaded Windows 10 according to the tutorial on YouTube above. It seems to work fine except for the fact that I have a 27" 5K Retina iMac and the display size is a measly (8 X 8)'. I have to...