CHANGING TEXT/BACKGROUND COLOR IN TABLES

Expressions:
=>go to visual cues
=>set upper ,lower
=>select colors for all level

the selected colors will b displayed in text

to select background change colors for the background jst adjacent to the
text color

Dimensions:
=>select the dimension and click on the '+' sign
=>select text color/background color
=>write an if loop for various colors for ex:if v want to show

red for 0 value, green for values between 0 and 0.15,and blue for others

=if(Discount=0,RGB(255,0,0), //red
if(Discount>0 and Discount<=0.15,RGB(0,255,0), //green
if(Discount>0.15,RGB(0,0,255) //blue
)
)
)

CHANGING COLOR WITH TIME:

=if(mid(now(1),17,1)=1,rgb(255,0,0),//red
          if(mid(now(1),17,1)=4,rgb(255,120,0),//orange
               if(mid(now(1),17,1)=7,rgb(0,255,0),//green
                    if(mid(now(1),17,1)=9,rgb(0,0,255)//blue
                      )