Forum Discussion
Conditional formating rows in sharepoint list based on values
- Mar 02, 2023
HI Chonski950
this is conditional row formatting.
Go to your list in SharePoint and select "All Items"->Format current view
select "Conditional Formatting"
Now set the set the formatting for "Show all values as" to green as a default.
Now click "Add a Rule"
and select the rule and Formattig you want to apply
You can add multiple rules likeif column 1 is equal to "00000000" then red
if column 9 is equal to "" (nothing, just leave empty) then orange
if column 10 is equal to "" (nothing, just leave empty) then orange
if column 11 is equal to "" (nothing, just leave empty) then orange
if column 13 is equal to "" (nothing, just leave empty) then orange
(You already set the column to be displayed in green in the default settings above)
Save these rules
Best Regards,
Sven
HI Chonski950
this is conditional row formatting.
Go to your list in SharePoint and select "All Items"->Format current view
select "Conditional Formatting"
Now set the set the formatting for "Show all values as" to green as a default.
Now click "Add a Rule"
and select the rule and Formattig you want to apply
You can add multiple rules like
if column 1 is equal to "00000000" then red
if column 9 is equal to "" (nothing, just leave empty) then orange
if column 10 is equal to "" (nothing, just leave empty) then orange
if column 11 is equal to "" (nothing, just leave empty) then orange
if column 13 is equal to "" (nothing, just leave empty) then orange
(You already set the column to be displayed in green in the default settings above)
Save these rules
Best Regards,
Sven
- Chonski950Mar 02, 2023Copper ContributorMany thanks! It worked! Hadn't thought it would be so easy :).
Cheers