User Profile
Laurie88
Copper Contributor
Joined Jan 26, 2021
User Widgets
Recent Discussions
SharePoint List - Highlight a cell based on status of a different cell
Hi there, I would like to format some date cells on a SharePoint List so they are highlighted a different colour if the corresponding cell on the adjacent column has 'Confirmed' entered. I've added a mock up of how it would look ideally: Basically we need to have a quick view of the status of the date through formatting. I'd like to hide the condition column as there will be quite a few of them (mulitiple date columns). I can then manually choose if a date is provisional or confirmed and other users will be able to see the status of the date only from the date cell. Any help would be really appreciated!
