Forum Discussion
Conditional Formatting based on User
What is the function syntax in conditional formatting to highlight the entered text with specific colors based on the 365 user account logged in? We aren't getting errors, but the syntax we try is not working.
2 Replies
Do you have user list in cells and when a user login, how you are capturing the logged-in user name? Can you please show some sample data and desired output?
We have not created a list of users or captured the logged in user. Since these are 365 accounts, we thought we could create a conditional format based on the user currently logged in. In Powerapps we use the function "User().FullName" to filter views or part of a last name with "in Concat" to filter and CountRows.
With multiple users sharing a spreadsheet simultaneously to enter data we are trying to capture which user is entering the data values, so we can get a count of how many each user is entering.
