Conditional formatting for textlist?

[Christian-P]

Hi Sarry,

I think you put the number in quotes which is causing this behavior.

Just leave the quotes and do something like this:

if Cell.Value <= 2 then
     Cell.Font.Color.SetRGBColor(RGB(0, 255, 0))  
else
     Cell.Font.Color.SetRGBColor(RGB(255, 0, 0))  
end if

Regards

Christian

[Sarry]

Hi,

you are right I have used quotes but without quotes it is not functioning at all and giving me the color Red even though It shouldn't be.

Regards

[Sarry]

Hi,

I would also like to mention that all the values which are present in a table are obtained using the str command. Can it make a diiference?

Regards

Sarry