Windows 10: Conditional Formatting

Discus and support Conditional Formatting in Windows 10 Gaming to solve the problem; 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... Discussion in 'Windows 10 Gaming' started by Jw888888, May 16, 2023.

  1. Jw888888 Win User

    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 every time a revised ship date that is enter that is later than the estimated ship date it highlights the revised ship date red. I used conditional formatting to highlight the cells when there is 1 finite date. However in my case I have a whole range of dates I need to compare to. Any help is appreciated J

    :)
     
    Jw888888, May 16, 2023
    #1
  2. donnylad Win User

    Conditional formating

    Okay,, the example is just a small sample of my data.
    Lie I said , I want a cell that is an L to have a red fill if the cell below is > 8.
    The cell contents can change and that is why I need to use conditional formatting.
    But I need help on how to do it.
    You can find the conditional formatting icon in the Home tab at the top.
    Len


    Conditional Formatting 221206d1547730612t-conditional-formating-capture.png
     
    donnylad, May 16, 2023
    #2
  3. 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, May 16, 2023
    #3
  4. Conditional Formatting

    Conditional formating

    Hi again,

    After a little thought you could use this in a cell to combine both checks for the conditional formula.

    Inserted into cell B7,
    =IF(B2="W","",IF(B2="L",IF(B3<8,2,"")))

    Inserted into cell B8,
    =IF(B4="W","",IF(B4="L",IF(B5<8,2,"")))

    This is looking at both cells (B2 & B3) & (B4 & B5) for the comparison checks. Change cell references (B2 & B3) & (B4 & B5) for each cell you want to check.


    Conditional Formatting 221269d1547763794t-conditional-formating-excel-conditional-formating.jpg


    The conditional formula for cell B2 is =B7=2, for the range of your cells.

    Conditional Formatting 221273d1547764050t-conditional-formating-condition1-formating.jpg


    The conditional formula for cell B4 is =B8=2, for the range of your cells.

    Conditional Formatting 221272d1547764050t-conditional-formating-condition2-formating.jpg
     
    Lottiemansion, May 16, 2023
    #4
Thema:

Conditional Formatting

Loading...
  1. Conditional Formatting - Similar Threads - Conditional Formatting

  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 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...