1 Reply Latest reply on May 8, 2012 4:18 PM by Tracy Rodgers

    highlighting one cell

      Is there way where I can just highlight one cell vs. the whole row or column?

        • 1. Re: highlighting one cell
          Tracy Rodgers

          Hi Betty,

           

          This can be done by creating a very specific calculated field, similar to the following:

           

          if State='Illinois' and year([Order Date])=2010 and [Order Priority]='Low' then 1 else 0 end

           

          Then, change the Mark Type to bar or Gantt. Place the above calculation on both the color and the size shelf. Right click on the calculation on the color shelf and select Discrete. Then, edit the colors as desired. Also, edit the size legend so that all the sizes are set to largest.

           

          Hope this helps!

           

          -Tracy