Forum Discussion

Leslie Ross's avatar
Leslie Ross
Copper Contributor
Sep 26, 2018

Custom conditional format in multi-line wrapped cells

I am trying to apply a custom formatting rule to the following type of situation:   Col S Col T         Carefully stripping off and removing roof boarding and roof sarking       ...
Excel
  • Leslie Ross's avatar
    Leslie Ross
    Copper Contributor
    Sep 27, 2018

    Thanks for the input. I see where my mistake occurred.

     

    It seems that indenting is not available in conditional formatting - might try a simple macro instead.

     

    leslie

    • Lorenzo Kim's avatar
      Lorenzo Kim
      Bronze Contributor
      Sep 27, 2018
      good luck..
    • Lorenzo Kim's avatar
      Lorenzo Kim
      Bronze Contributor
      Sep 28, 2018

      pls find attached revised file.

      I changed it to indent 2 spaces (you may change that in Manage rules)

      I also provided a VBA - hope you can make something out of it.

      thanks..

Resources