Mar 04 2021 11:20 AM - edited Mar 04 2021 11:21 AM
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. how to see that data only.
Please help...
Mar 04 2021 11:37 AM
Here are some examples in the inserted template file for your project.
The easiest solution:
With the left mouse button pressed, select the area from which this formatting should be.
Go to Conditional Formatting
Select "New Rule"
Click "Format only cells that contain ..."
Format cells only with:
Cell value - less than - 300
Click on the "Format ..." button
Opens a new window "Shape cells"
font
Color white
Press OK until the end
After that, the values below 300 can no longer be seen in all cells, but they can still be totaled.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Mar 05 2021 10:19 AM
Mar 05 2021 11:27 AM
You may apply custom number format
In the first row numbers are without formatting, in the second one with format applied as above.
Mar 05 2021 11:33 AM
Mar 05 2021 11:36 AM
Mar 05 2021 11:36 AM
Mar 05 2021 11:57 AM
Solution
Mar 05 2021 11:57 AM
Solution