Bill, I do really appreciate your giving up your time to help me with this. It seems I have a complete block with this routine
Essentially what I'm after is My grid has 6 columns and 6 rows The underlying data in the table, Col 3, row 2 is a character field and says "MY TEAM v BYE" What I want to do is, if it contains the word BYE, color this cell Grey Not the row, not the column, just this cell It's just not working for me. On Fri, Oct 12, 2012 at 3:12 PM, Bill Arnold < [email protected]> wrote: > Sytze, > > Friends > Sorry about my stuff up with the comma > Of course, it was a typo with rgb(192,19,2,192) > > Even so, I can't get it to work > I've even tried > col1="RGB(192,192,192)" > col2="RGB(255,255,255)" > colcond=IIF(AT("BYE",sp605.courtc6)=0,.f.,.t.) > Thisform.Grid1.Columns(7).DynamicBackColor = "IIF(colcond,&col1,&col2)" > > I'll now move on > > ------------------------------------------------ > > Maybe some comments will help: > > Coming into the icase command below, rgc_jt1 (through 7) contain RGB > expressions e.g. "rgb(255,255,128)" obtained from a control table in the > code above. > It doesn't matter how these RGB strings were obtained, so long as they > exist > when the grid's dynamicbackcolors are set by the code below > > Using the expression &rgc_jt1 in the icase command converts the RGB string > into its numeric equivalent, e.g. 8454143 > > > * Sunday column > Thisform.Grid1.Columns(1).DynamicBackColor = ; > "icase(atc(trim(wschctls.jt1name),gridjobs.sun) <> 0, &rgb_jt1, " + ; > "atc(trim(wschctls.jt2name),gridjobs.sun) <> 0, &rgb_jt2, " + ; > "atc(trim(wschctls.jt3name),gridjobs.sun) <> 0, &rgb_jt3, " + ; > "atc(trim(wschctls.jt4name),gridjobs.sun) <> 0, &rgb_jt4, " + ; > "atc(trim(wschctls.jt5name),gridjobs.sun) <> 0, &rgb_jt5, " + ; > "atc(trim(wschctls.jt6name),gridjobs.sun) <> 0, &rgb_jt6, " + ; > "atc(trim(wschctls.jt7name),gridjobs.sun) <> 0, > &rgb_jt7,RGB(255,255,255))" > > > WSCHCTLS.JTxNAME is a job type, e.g. "service call" (there are 7 > possibilities) > > Gridjobs.sun is a string of info extracted from a job scheduled for a given > column's day of week. This string contains embedded job types, e.g. > "service > call". > > When a string contains a job type that matches one of those in the list (of > 7), the cell's color is set to its corresponding &rgc_jtx value. > > If no match is found for the job type, the default color is set to > RGB(255,255,255) > > The icase command references colors using both numeric values and an RGB > expression. > > > Bill > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAG1nNy-SB5z6NNGww3Pn-BVpY5jnoZotrOA=r-qgqa93+am...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
