Forum Discussion
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...
- 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
Thank you so much sir for reply.
Is there ant alternative way to in large data I want to see only data which is above 300. how to see that data only.
Is there ant alternative way to in large data I want to see only data which is above 300. how to see that data only.
I believe the approach suggested by Mr Baklan is best for you. You don't even need conditional formatting.
Thank you for your understanding and patience,
Nikolino
Thank you for your understanding and patience,
Nikolino
- 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😊😊- 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