setting back color of a row

Posted by: geneatsb on 8 September 2017, 1:01 pm EST

  • Posted 8 September 2017, 1:01 pm EST

    Hello all,


     


             I'm having a little trouble trying to set the back color of a particular row dynamically in my spread. I want to set the color of the entire row red if a condition is met. Any help is appreciated.


     


    Gene

  • Replied 8 September 2017, 1:01 pm EST

    Gene -

    What type of problem are you having?  As long as your condition is met it should be as simple as...

    FpSpread1.ActiveSheet.Rows(2).BackColor = Color.Blue
  • Replied 8 September 2017, 1:01 pm EST

    oh thanks,


     


    for some reason I thought you couldn't set it like that, just get it. Thanks.


     


    Gene

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels