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. Using condition formatting, I am trying to change the colour of cell based on a date.

    in Windows 10 Gaming
    Using condition formatting, I am trying to change the colour of cell based on a date.: Using condition formatting, I am trying to change the colour of a cell based on a date. The idea is that if a training certificate expires in 2 months the cell will turn green.If the training certificate expires in 1 month time the cell will turn yellow.If the training...

  3. Using condition formatting, I am trying to change the colour of cell based on a date.

    in Windows 10 Software and Apps
    Using condition formatting, I am trying to change the colour of cell based on a date.: Using condition formatting, I am trying to change the colour of a cell based on a date. The idea is that if a training certificate expires in 2 months the cell will turn green.If the training certificate expires in 1 month time the cell will turn yellow.If the training...

  4. Conditional formatting oddity?

    in Windows 10 Customization
    Conditional formatting oddity?: I'm running Excel 2021 on Windows 10 Pro 64-bit.I seem to be having some form of delay with the application of Conditional Formatting,where I have to scroll past the cells subject to the formatting, before the effect takes place.Sheet2 looks like: I want the conditional...

  5. Conditional formatting oddity?

    in Windows 10 Gaming
    Conditional formatting oddity?: I'm running Excel 2021 on Windows 10 Pro 64-bit.I seem to be having some form of delay with the application of Conditional Formatting,where I have to scroll past the cells subject to the formatting, before the effect takes place.Sheet2 looks like: I want the conditional...

  6. Conditional formatting oddity?

    in Windows 10 Software and Apps
    Conditional formatting oddity?: I'm running Excel 2021 on Windows 10 Pro 64-bit.I seem to be having some form of delay with the application of Conditional Formatting,where I have to scroll past the cells subject to the formatting, before the effect takes place.Sheet2 looks like: I want the conditional...

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

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

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

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

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