Conditional formatting with two variables not working

[codemancode]

Afternoon every one!



I am trying to get a conditional formatting rule that formats a cell based on two conditions. Condition one is that the cell has a value greater than 0. Condition 2 is that the cell is in a column that has a date that occurred before today. For example, cell B4 should be formatted red, based on the fact that it is greater than 0, and its in a Tuesday column, and today is Wednesday. I have tried and i have also tried putting today's date and 0 in a separate cell to make them absolute references, and still it wont work. I know im on the right track but im sure there is something simple i have done wrong.



Thank you all for your help,

Codemancode

[Fluff13]

Select A2:F4 and use this
=AND(A2 > 0,A$1 < TODAY())
(Remove the spaces)