asked on 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.CellBackCol
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.CellBackCol
Visual Basic Classic
Last Comment
Hishamullah Alwee
ASKER CERTIFIED SOLUTION
Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
or
Learn why we charge membership fees
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.
ask a question
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!Lowerli
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.
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!Lowerli
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!
James Murphy
That works