Conditional Formatting Based on Modifier

kendra123

Is there a way to do conditional formatting based on who modified /made changes into the sheet? I have multiple users covering projects and would like to be able to see who was responsible for editing each task. This particular workflow needs to use a horizontal schedule/flow versus a vertical one like most projects. example - if "user a" edited/populated column x then i want it blue or if "user b" edited i want it green.

Adam Murphy

I don't see why not:

Just add a rule and select the user for each rule.

sfcrews

There is a built in column that you can add to your sheet called "Modified By"

You can then add a conditional format based on that column.