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. Can't reset Windows 10 Surface 3 to factory condition - stuck on boot page

    in Windows 10 Installation and Upgrade
    Can't reset Windows 10 Surface 3 to factory condition - stuck on boot page: Hello I have a Microsoft Surface 3 not pro and I am trying to reset to factory condition. I was unable to do it on the computer itself by selecting reset under security settings, it simply didn't work. i created on another pc a USB bootable drive as per ms instructions....
  3. Windows hello not unlocking PC in dark conditions

    in Windows Hello & Lockscreen
    Windows hello not unlocking PC in dark conditions: My laptop's windows hello feature has been a headache for a while now. Every once in a while the windows hello messes up and doesn't recognise my face in the dark anymore, despite the IR lights illuminating. The only fix ive found is to reset my PC but i can't keep doing that...
  4. Conditional Access within InTune/Azure

    in AntiVirus, Firewalls and System Security
    Conditional Access within InTune/Azure: I am looking to set up conditional access to only allow 'Corporate' device to access some of our cloud apps. I have set up a conditional access rule that by default block access to the specified apps, but have an exclusion group for all corporate devices. This group is a...
  5. Bluetooth Disappears from notification center in several conditions

    in Windows 10 Drivers and Hardware
    Bluetooth Disappears from notification center in several conditions: My Laptop when wakes from sleep mode or when i close and open my Laptops lid My Bluetooth option disappears from Notification center, Sometimes even i restart the laptop it is not shown back and i have to restart it several times to start the services back for Bluetooth and...
  6. Windows suddenly turns into Locking condition

    in Windows 10 BSOD Crashes and Debugging
    Windows suddenly turns into Locking condition: Hi all friends , I have a problem on my Lenovo Ideapad 700 laptop , suddenly it shows Hibernating... with a circle and just after that , it turns into Locking page and then shuts down. I have this problem on plugged and unplugged both and i cannot solve this problem,...
  7. monitor changing color temperature under certain conditions

    in Windows 10 Customization
    monitor changing color temperature under certain conditions: Hi, I got a color shifting problem. The colors of my entire screen switch suddenly to a greener\ yellowish tint most of the time. I bought recently a new screen and because of a hardware issue I got it changed already I had some lines showing up on the first screen but the...
  8. 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;...
  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. 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