Conditional formating

Page 1 of 3 123 LastLast

  1. Posts : 166
    microsoft windows 10
       #1

    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
      My Computer

  2. jimbo45's Avatar
    Posts : 10,815
    Windows / Linux : Arch Linux
       #2

    donnylad said:
    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
    Hi there

    ????

    I use EXCEL a lot but haven't a clue what you are asking for
    Can you be a bit more specific / post what you've got now and what you want to do.

    Cheers
    jimbo
      My Computer


  3. Posts : 166
    microsoft windows 10
    Thread Starter
       #3

    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 formating-capture.png
      My Computer

  4. Lottiemansion's Avatar
    Posts : 105
    Windows 10 Home 64 Bit
       #4

    Hi,
    I have managed this but it needs to be a three stage process.
    Firstly set a cell to show a value of one if the letter is L.
    Then set another cell to show the value one if the cell value is below 8.
    Now add these two cells together & if the value is 2 then colour the box red.
    This can be hidden/ done on another sheet too.
    See included example!
    Attachment 221213
    Attached Thumbnails Attached Thumbnails Conditional formating-excel-conditional-formating.jpg  
    Conditional formating Attached Files
      My Computer


  5. Posts : 166
    microsoft windows 10
    Thread Starter
       #5

    Im sorry but I did not understand what you did and also the attachment you offered I cannot open as it said it was invalid.
    Len
      My Computer

  6. Try3's Avatar
    Posts : 8,696
    Windows 10 Home x64 Version 21H1 Build 19043.1110
       #6

    Len,

    You could retry the attachment now. I've just been able to open it without any problems. [Perhaps @Lottiemansion has altered it since your first try]

    Denis
      My Computer

  7. Sheltieuk's Avatar
    Posts : 88
    Windows 10 Version 1909 Pro(OS build 18363.778
       #7

    donnylad said:
    Im sorry but I did not understand what you did and also the attachment you offered I cannot open as it said it was invalid.
    Len
    You need to click the link at the bottom of the image it opens fine from that.
      My Computer


  8. Posts : 166
    microsoft windows 10
    Thread Starter
       #8

    Yes I see the diagram now but still don't know how its done, could you explain in more detail please.
    Len
      My Computer

  9. Try3's Avatar
    Posts : 8,696
    Windows 10 Home x64 Version 21H1 Build 19043.1110
       #9

    Len,

    It is easier to explain for the top half only. The bottom half is done the same way.

    Conditional formating-xlsxsnip.png

    Rows 8 & 9 contain formulas that assess the state of your input rows 1 & 2.
    - Row 8 assesses If YourInputRow2 less than 8 then 1 otherwise 0
    - Row 9 assesses If YourInputRow1 is L then 1 otherwise 0

    Row 7 adds these two results together [I used the label "Add both of the results below"]. So, for example, the total would be 2 if both input row 2 is less than 8 and input row 1 is L.

    In your input row 1, select the cell and look in Conditional formatting, Manage rules. You'll see that the red highlight is applied if row 7 has the value 2.

    In other words, the red highlight is applied if both input row 2 is less than 8 and input row 1 is L.

    Denis
      My Computer


  10. Posts : 166
    microsoft windows 10
    Thread Starter
       #10

    Just got n,,,,,thought I would have a look at the video first but when I clicked on it , it said video unavailable for some reason, I will try the formula tomorrow.
    Len
      My Computer


 
Page 1 of 3 123 LastLast

  Related Discussions
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 08:54.
Find Us




Windows 10 Forums