Conditional Column Formatting and color set

 

Step-1 :

Create a new page and select Classic Report.

--> SQL Query :

 select EMPLOYEE_ID,FULLNAME,F_DEPT(DEPARTMENT_ID) DEPARTMENT,BASIC_SALARY,

       case when BASIC_SALARY < 10000 then 'red'

            when BASIC_SALARY between 10000 and 20000 then 'purple'

            when BASIC_SALARY > 20000 then 'green'

       end the_color

  from EMPLOYEES

Step-2 :

--> Hidden item : the_color

Step-3 : 

--> HTML Expression on "BASIC_SALARY" item

 <span style="color:#THE_COLOR#;font-weight:bold;">#BASIC_SALARY#</span>