Windows 10: Conditional formatting oddity?

Discus and support Conditional formatting oddity? in Windows 10 Software and Apps to solve the problem; 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... Discussion in 'Windows 10 Software and Apps' started by GeorgeSinkinson, Oct 31, 2024.

  1. 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 formatting to affect any cell in $B$6:$F$91 that matches

    :)
     
    GeorgeSinkinson, Oct 31, 2024
    #1
  2. spapakons Win User

    USB Port Oddities


    Ok, let's see it with pictures step-by-step. First right-click on the USB device and select Update driver software:


    Conditional formatting oddity? 47717d1485959446t-usb-port-oddities-replace-usb-drivers-step-1.jpg


    Then select Browse my computer for driver software (LAST option) :


    Conditional formatting oddity? 47718d1485959446t-usb-port-oddities-replace-usb-drivers-step-2.jpg


    The select Let me pick from a list of device drivers on my computer (LAST option) :


    Conditional formatting oddity? 47719d1485959446t-usb-port-oddities-replace-usb-drivers-step-3.jpg


    Then select the standard driver from the list and click next:


    Conditional formatting oddity? 47720d1485959446t-usb-port-oddities-replace-usb-drivers-step-4.jpg


    Click next/OK as required to complete installation. Repeat the steps for all Intel USB devices. Finally click on each USB root device and press DEL to delete it, reply YES when asked. After deleting all USB root devices restart the computer.

    I hope this is detailed enough...
     
    spapakons, Oct 31, 2024
    #2
  3. Vince R. Win User
    Text disappearing when conditional format applied?

    Hello! Han2708

    Thank you for posting in Microsoft Community

    I understand that you are experiencing an issue with text disappearing when conditional formatting is applied in Excel.

    Allow me to ask:

    • What version and edition of Office do you have installed in your device? Example: Personal/Family/Enterprise?
      • You can open any Office apps
      • Go to File > Accounts - on the right side you can see Product Information
    • What error message are you getting?
    • Is the file shared by someone else? or originally created by you?

    To resolve this issue, you can try the following steps:



    1. Select the cell(s) where the text is disappearing.

    2. Go to the "Home" tab in the Excel ribbon.

    3. Click on the "Conditional Formatting" button and select "Manage Rules".

    4. In the "Manage Rules" dialog box, select the rule that is causing the issue.

    5. Click on the "Edit Rule" button.

    6. In the "Edit Formatting Rule" dialog box, make sure that the "Stop If True" checkbox is unchecked.

    7. Click on the "OK" button to save the changes.



    This should prevent the text from disappearing when the conditional formatting is applied.

    We will also leave the thread open for any volunteer moderators to join in and share their opinion/suggestions to help you with your concern.

    Thank you,

    Vince

    Microsoft Community Moderator
     
    Vince R., Oct 31, 2024
    #3
  4. DaveM121 Win User

    Conditional formatting oddity?

    Conditional Formatting

    Hi J,

    I am Dave, I will help you with this.

    If you select the first revised ship date cell and select Conditional Formatting - Highlight Rules - Greater than and then click the corresponding estimated shipping date cell, that should set the conditional formatting for that cell.

    Then to apply that rule to all other cells in that column, select that cell, then click 'Format Painter' and click the cell below that cell and drag down to fill the column with the same conditional formatting rule.
     
    DaveM121, Oct 31, 2024
    #4
Thema:

Conditional formatting oddity?

Loading...
  1. Conditional formatting oddity? - Similar Threads - Conditional formatting oddity

  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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
  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