Changing the background color of a text box based on the value in a table

[rahul325]

In the attached image, I want to be able to change the background color of the text box ( Baseline) based on the value in the column "Baseline Finish". How can I do that?

[MFGF]

In the attached image, I want to be able to change the background color of the text box ( Baseline) based on the value in the column "Baseline Finish". How can I do that?

Hi,

In your image there appears to be one text box, but many different values for Baseline Finish. Can you explain your requirement? Which value of Baseline Finish should dictate the colour of the text box? The maximum? Minimum? First? Last? Something else?

The actual process will utilise an advanced conditional style, but the condition will be dictated by the answer you provide to the above question...

Cheers!

MF.

[rahul325]

Hi,

In your image there appears to be one text box, but many different values for Baseline Finish. Can you explain your requirement? Which value of Baseline Finish should dictate the colour of the text box? The maximum? Minimum? First? Last? Something else?

The image is one text box.
I need to be able to change the color of the text box based on All or Nothing, I mean, if all boxes are populated, background color green. If none are populated, background color yellow.


Thanks a lot, appreciate your help :)

[MFGF]

The image is one text box.
I need to be able to change the color of the text box based on All or Nothing, I mean, if all boxes are populated, background color green. If none are populated, background color yellow.


Thanks a lot, appreciate your help :)

What is the requirement if some are populated but not others?

MF.

[rahul325]

What is the requirement if some are populated but not others?

MF.

Leave background as white.

[BigChris]

You don't mention what type of data you're using (relational / dimensional), so I'm going to assume relational. What result do you get in your example if you calculate Minimum([Actual Finish])?

[rahul325]

You don't mention what type of data you're using (relational / dimensional), so I'm going to assume relational. What result do you get in your example if you calculate Minimum([Actual Finish])?

I need to look at the Baseline Finish column. I did a Minimum([Actual Finish]) and got 10/9/17.

The Actual Finish column will NOT have all rows populated, the Baseline Finish column WILL have all rows either populated or NOT. That's why I want to check for All or None on that column.


Thanks for all the help!

[MFGF]

I need to look at the Baseline Finish column. I did a Minimum([Actual Finish]) and got 10/9/17.

The Actual Finish column will NOT have all rows populated, the Baseline Finish column WILL have all rows either populated or NOT. That's why I want to check for All or None on that column.


Thanks for all the help!

I guess the expression will be maximum([Baseline Finish]) is not null
You can then conditionally format your text box based on this being true or false

This assumes you're using a relational package rather than a dimensional package.

MF.