Forum Discussion
Excel
Mar 04, 2021Iron Contributor
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...
- Mar 05, 2021Here 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
Excel
Mar 05, 2021Iron Contributor
Yes sirπ
Your method is also great for easily see to which criteria is less or high.
Thank you so much sir hor helipng meππ
Your method is also great for easily see to which criteria is less or high.
Thank you so much sir hor helipng meππ
NikolinoDE
Mar 05, 2021Platinum Contributor
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