Dynamic Conditional Formatting in Tables

Hello ..   I want to be able to set the format of a table cell color based on another data column rather than hardcoding the highest and/or lowest values.  The value in column A should be Red or Gr...