Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Conditional formatting rules and user-based formatting

Monica Evanchik
Monica Evanchik ✭✭✭
edited 12/09/19 in Archived 2016 Posts



If I set up a rule that all past due dates are color-coded red, but somebody else goes in and changes the text color to blue, will it override the conditional formatting? Can I lock it so that it can't be changed?






  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭



    Two competing things here. 

    Cell/row/column formatting is what you see if no conditional formatting is active*.

    What you (normally) see when looking at a sheet is the cell/row/column formatting overwritten as determined by the conditional formatting.


    So, if your user colors everything blue and there is a rule that says dates in the past will be red, then everything will be blue EXCEPT the dates are in the past.


    Be aware that conditional formatting for a particular item is a first-come-first-serve thing. If you have a rule that says the column is red when a date colum is in the past and another that that says the whole row is blue when something else is true, you migtht see a row that is blue with a red column. 


    I think I used too many words.

    Conditional formatting wins.

    No, you can't prevent another admin from changing the rules. 


    *active means enabled. Conditional formatting can be disabled in the dialog box.




  • JamesR
    JamesR ✭✭✭✭✭✭

    Just to clarify what Craig says about conditional formatting.  The rules at the top of the list out rant all the rules below them. i.e. If you have 10 rules then rules rule 5 is out ranked by rules 1-4 but out ranks rows 6-10.



This discussion has been closed.