Conditional Formatting

[Robandemmy]

Hello,

I have a worksheet containing 12 columns (January - December) and 75 rows (various products). I want to conditionally format each row to highlight price evolution (ie if product X is $20000 in Jan, then $22000 in Feb, highlight red, if $19000 in Mar then highlight green). I can successfully do this for one row but cannot find a way to apply this to all 75 rows without the formatting being applied to the entire sheet, not each row individually. A non VBA solution would be preferred but I will take what I can get!

 

[etaf]

are you comparing only to January price or previous month ?
if previous month
assuming the values are in A2 : L76
select A2:A76

now add 2 rules
A2 < B2
and
A2 > B2
should work
we could add an AND so that the cell is not blank