color cells in a msFlexgrid based on cell contents using vb6
group rows by color
i am trying to determine how to write code to group colors of cells that have the same file name in the first column Col 0 using a msflexgrid.
eg; if the row has the same file name the the color of the rows will all be the same until the filename changes then a different color
gridWinslosses.CellBackColor
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
I want to create two colors in 1 column (Remark Section) based on three situations :
Situation 1 : If Total Weight is Over than Upperlimit, will come out RED Color (Backcolor)
If Wt >= RsParts.Fields!Upperlimit Then
LowerUpper "This Part Weight is OVER than UpperLimit"
Situation 2 : If Total Weight is LESS than Lowerlimit, will come out RED Color (Backcolor)
If Wt <= RsParts.Fields!Lowerlimit Then
LowerUpper "This Part Weight is LESS than Lowerlimit"
Situation 3 : If Total Weight is OK (In Spec), will come out GREEN Color (Backcolor)
If Wt <> RsParts.Fields!Upperlimit or Wt<>RsParts.Fields!Lowerlimit then
LowerUpper "This Part Weight is OK !"
So, when each time calibrate with Weighing Machine then display output (LowerLimit, Upperlimit or OK (In Spec)) at MsFlexGrid, I want to show 2 Colors in 1 Column only based on 3 situations.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
That works