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
    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
    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
    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
    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. Text disappearing when conditional format applied?

    in Windows 10 Gaming
    Text disappearing when conditional format applied?: Just set up conditional formatting to change colour on a cell depending on input of a different cell. This happens but where there is data in the original cell it disappears? Can anyone help me on how I stop this happening please...

  3. Text disappearing when conditional format applied?

    in Windows 10 Software and Apps
    Text disappearing when conditional format applied?: Just set up conditional formatting to change colour on a cell depending on input of a different cell. This happens but where there is data in the original cell it disappears? Can anyone help me on how I stop this happening please...

  4. Text disappearing when conditional format applied?

    in Windows 10 Network and Sharing
    Text disappearing when conditional format applied?: Just set up conditional formatting to change colour on a cell depending on input of a different cell. This happens but where there is data in the original cell it disappears? Can anyone help me on how I stop this happening please...

  5. Conditional formatting problem

    in Windows 10 Gaming
    Conditional formatting problem: I need conditional formatting to compare 2 lists of numbers with the goal of formatting numbers not in the second list. The first list has 300 numbers; the second list has 2000 numbers. Here is a formula I've tried unsuccessfully. It formats all 300 numbers in the first list...

  6. Conditional formatting problem

    in Windows 10 Software and Apps
    Conditional formatting problem: I need conditional formatting to compare 2 lists of numbers with the goal of formatting numbers not in the second list. The first list has 300 numbers; the second list has 2000 numbers. Here is a formula I've tried unsuccessfully. It formats all 300 numbers in the first list...

  7. Conditional Formatting

    in Windows 10 Gaming
    Conditional Formatting: Hello!I am trying to use excel to highlight a revised ship date. I have a column of estimated ship dates and revised ship dates. The estimated ship dates can range from any date in the week ie 5/16, 5/17 etc The revised ship date is changed manually. How can I format excel so...

  8. Conditional Formatting

    in Windows 10 Software and Apps
    Conditional Formatting: Hello!I am trying to use excel to highlight a revised ship date. I have a column of estimated ship dates and revised ship dates. The estimated ship dates can range from any date in the week ie 5/16, 5/17 etc The revised ship date is changed manually. How can I format excel so...

  9. Conditional format not automatically updating - Follow on

    in Windows 10 BSOD Crashes and Debugging
    Conditional format not automatically updating - Follow on: I previously asked this question but all answers proved unsuccessful. I can now post the solution, in case it helps anyone. [ATTACH] https://answers.microsoft.com/en-us/windows/forum/all/conditional-format-not-automatically-updating/4de58717-6479-4428-b511-f996396fa3db

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

Users found this page by searching for:

  1. windows 10 rows formating

    ,

  2. conditional formatting broken in windows 10

    ,

  3. how to put conditional formating in windows 10

    ,
  4. Outlook 365 conditional formatting not working 2019