Change color in cell based on multiple cells

[Lerums]

Hello,

I have a question about changing color in a cell based on multiple cell values. I'll try to explain..

- Cell A2 contains a start date, lets say 05.01.19, this date is not constant and can be 4 week from now or tomarrow.
- I want cell A2 to change color to red or green, based on value in cell B2 are 0 or 100 when "todays date" has passed.
- So if cell B2 has value 100 01.01.19, then cell A2 will be green 05.01.19.
- But if cell A2 is 0 from 05.01.19 then A2 will be red.

So, something like this: If "B2 are higher then 99" and if "A2's date has passed todays date", then set "cell A2 to green or red".

A2 B2
Contains a start date Contains value 0 or 100

Is this possible?

I hope it is understandable

[etaf]

a sample sheet may help
but you will need two conditional format formulas for the different colour fills
Green OR Red - which is it ?
different rule for green , different rule for red

AND ( B2 > 99 , A2 > today() )