Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Change table cell colour depending on data entered

Avatar

Avatar
Validate 10
Level 1
usuggestaname
Level 1

Like

1 like

Total Posts

55 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 1
View profile

Avatar
Validate 10
Level 1
usuggestaname
Level 1

Like

1 like

Total Posts

55 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 1
View profile
usuggestaname
Level 1

02-09-2013

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.

View Entire Topic

Avatar

Avatar
Validate 10
Level 4
Bibhu_Bikash_Na
Level 4

Likes

37 likes

Total Posts

630 posts

Correct Reply

46 solutions
Top badges earned
Validate 10
Validate 1
Give Back 10
Give Back 5
Give Back 3
View profile

Avatar
Validate 10
Level 4
Bibhu_Bikash_Na
Level 4

Likes

37 likes

Total Posts

630 posts

Correct Reply

46 solutions
Top badges earned
Validate 10
Validate 1
Give Back 10
Give Back 5
Give Back 3
View profile
Bibhu_Bikash_Na
Level 4

02-09-2013

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.