Hi,
I want to conditional format a textInput based on it's values, between 9 & 10.6 would be Green and anything outside that would be red. However, I also want to format it to be white when there is no data in the TextInput box. The first part I can do but getting the box to remain white when there is no data is proving hard.
Any ideas what the formula would be for this?
Regards
Sean