There is a nak to conditional formatting Highlight the cells you want to change colour on and with the first cell selected do your formula. Before press enter or Oking the box click in the formula and remove the $.


it can be a pain and there are other ways but this does work with a bit of patience