Conditionally format table to create waterfall chart

I am trying to conditonally format this chart to highlight the background color to form a waterfall chart. F23 = P1 and I want to show rise or fall per month highlight the text box that corresponds to month and data tag. Is there a way to conditonally format this?