AnsweredAssumed Answered

Conditional format/Display Alternate Value

Question asked by Dave_2 on Oct 6, 2012
Latest reply on Oct 7, 2012 by philmodjunk

Title

Conditional format/Display Alternate Value

Post

     I am trying work out some conditional formatting in my layouts.  The key of this particular database it to track changes over time from one record to the next (always sorted by a "cue number").  So far I have been able to change the color of the text of a record if it is = its previous value.  

     My Question:  Can I also use conditional formatting to display an alternate value if the contents of a field has a particular value in it?

     When a field contains a '' (ditto mark) I would like it to display the last value that is not a ditto mark in parenthises (when sorted by "cue number).

     EX here is a table displaying actual values:

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
                    CUE                     Fix1                     Fix2                     Fix3                     Fix4
                    1                     CP3                     CP1                     CP4                     CP7
                    2                     ''                     ''                     ''                     CP7
                    3                     ''                     ''                     CP9                     ''
                    3.3                     ''                     ''                     ''                     CP5
                    3.7                     ''                     ''                     ''                     ''
                    5                     CP1                     CP1                     CP1                     CP1
                    9                     ''                     ''                     ''                     CP2
                                                                                                             

      

This is how the Table would need to actually display:

      

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       
                    CUE                     Fix1                     Fix2                     Fix3                     Fix4
                    1                     CP3                     CP1                     CP4                     CP7
                    2                     (CP3)                     (CP1)                     (CP4)                     CP7
                    3                     (CP3)                     (CP1)                     CP9                     (CP7)
                    3.3                     (CP3)                     (CP1)                     (CP9)                     CP5
                    3.7                     (CP3)                     (CP1)                     (CP9)                     (CP5)
                    5                     CP1                     CP1                     CP1                     CP1
                    9                     (CP1)                     (CP1)                     (CP1)                     CP2

      

     Any help would be appreaciated!

Outcomes