Change table cell colour depending on data entered

[usuggestaname]

Hi, I have a table in a form and I want the cells to have a darkened colour in each cell if it has no data entered but the cell background colour to change to white if any text is entered in the cell. Is there any way of doing this?  Thanks.

[Bibhu_Bikash_Na · Accepted solution]

You can use the fillColor property to do that. It depends on your table structure how are you gonna do this. If you have relatively small table lets say 3 columns. 3 rows then in each cell exit/calculate event you can put the following script.

if (Cell1.rawValue == null && Cell2.rawValue == null && Cell3.rawValue == null)
{
  Row1.fillColor = "255,0,0";
}
else{
  Row1.fillColor = "255,255,255";
}  

If you have got a bigger table, then you need to create a function for that.

Thanks,

Bibhu.

[usuggestaname]

Thanks Bibhu - that worked perfectly.