conditions

3 Topics

Conditional Formatting - Consider Only Value as Lowest Value
When "Formatting Cells Based on Value" if there is only one cell with data out of a set of otherwise blank cells, the rule considers the existent data as highest value. This makes sense logically, but I want the lowest value, even if it is the only value, to display as such. I can't figure out how to use another rule to eliminate the blank cells from the value-based rule. Thanks in advance!
Solved
Ben Smith
Aug 27, 2018 Place Excel
6.6KViews
0likes
2Comments
Hide column on top level but shown in sub-folder
Hi, What condition do I use to hide the column "Days Left Until Expiry" on the top level but when you open the sub-folder "Folder 1", it is visible? Thanks.
Solved
drishm13
May 12, 2021 Place SharePoint
3.3KViews
0likes
3Comments
IF formula error message "The formula contains a syntax error."
Hi all. I'm trying a very simple IF formula in a calculated column at my data list. =IF([Monitorar]=0;"0";"1") I tried replacing the ; by , and not solved. I also tried replacing IF by SE (note that my Microsoft account is in portuguese), and not solved. I tried in another browsers, an nothing different happens.
Solved
valderes-squadra
May 13, 2022 Place SharePoint
2.8KViews
0likes
4Comments