Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If a field = 'N' I want the 'N' to be displayed in red, if it is = 'Y', I want 'Y' in Green. I tried this, but it doesn't work:
=if(Conf_Rec_Date='N', Red(Conf_Rec_Date), Green(Conf_Rec_Date))
What am I doing wrong?
Thanks!!
Oh I see, is this for a dimension or expression?
For dimension:
For expression:
Try using the same expression as above
You want the color of the text box to be read or green or the text itself?
the text itself
You can use a calculated if statement to determine the color on the Font tab.
Try this condition:
=if(Conf_Rec_Date='N', Red(), Green())
This is in a pivot table, so the font tab doesn't let me specify which column, or if it is supposed to when I click on that "color" box that you circled, it doesn't--its sort of greyed out. As is "font" when I click on the "+" next to the dimension.
and using
=if(Conf_Rec_Date='N', Red(), Green())
in the expression box, puts "RGB(0,128,0)" in my chart field, in black text, when what I want is a green "Y"
Oh I see, is this for a dimension or expression?
For dimension:
For expression:
Try using the same expression as above
Oh, for goodness' sake...
I always thought since those options are greyed out that means they aren't available but this time I actually tried clicking on it and it worked! Thank you! I hope somebody plans on making that act more intuitively...
Hahahahaha