Link to home
Start Free TrialLog in
Avatar of isnoend2001
isnoend2001Flag for United States of America

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.CellBackColor
ASKER CERTIFIED SOLUTION
Avatar of eemit
eemit
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of isnoend2001

ASKER

thank you
That works
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.