Adding color to one section of a grid

[amwprogg]

Hi all.
I have a grid and one of the columns of the grid is a number (a running total) - and I want to add color to the grid - if the total is zero to 3 I want the cell to be green - if 4-5 I want it to be amber (orange) - above 5 red.
Like traffic lights really.
Based on the value of the total, how can I color one cell of my grid?
Andy.

 

[Mike Lewis]

Andy,

Check the help topics on DynamicBackColor and DynamicForeColor. They include examples that do more or less what you want.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[lordhawkins]

Using the dynamicbackcolor property. Consult the VFP help file that shows an example, and extrapolate from there.

 

[ChrisRChamberlain]

Andy

Another alternative

How can I color code cells in a grid? faq184-624

FAQ184-2483 - answering getting answered.​

Chris
PDFcommander[sup]tm[/sup].net
PDFcommander[sup]tm[/sup].com

 

[darrellblackhawk]

Just a small point...

If you use a dynamic property in a grid, you can get some pretty confusing slowdowns during debugging.

To avoid this, add a property to the form to conditionally add the dynamic property.

i.e. (In the grid's init method)

if !thisform.bDebugging
this.dynamicforecolor = ...
endif

Darrell

 

[amwprogg]

Thanks all for your valuable contributions. I think I'll be able to sort out my problem now.
Andy.