Forum Discussion

Excel's avatar
Excel
Iron Contributor
Mar 04, 2021
Solved

Conditional Formatting

Hello Everyone,    In above screenshot,  my condition was above 300 so I can see rent was highlight and food 350 was highlight. But in large data I want to see only data which is above 300. h...
  • NikolinoDE's avatar
    NikolinoDE
    Mar 05, 2021

    Excel 

     

    Here is a small example, also with conditional formatting.
    Example in the inserted file.
    If you go into the blank cells, you will see values in them.
    You can change any value to any number.
    If any number is greater than 300, the cell will turn yellow when the number below 300 in the cell disappears.
     
    If you liked our help, please give us (everyone involved) a thumbs up and by clicking on correct answer for the solution proposal without conditional formatting (is also the most suitable).
    This way, other members will also be able to benefit from it.
     
    Thank you,
     
    Nikolino
     
     

Resources