Formula, Conditional Formula Needed
Select range N7:N31
Conditional Formatting
=AND(MOD(ROW(N7),12)=7,MIN($N$7,$N$19,$N$31)=N7)
Format as Green
"Karl" wrote:
I have a spreadsheet where I have a value in cell n7,n19 and n31 I want to
have the cell of those 3 with the lowest number between them to turn green
and the other cells stay as they are. Thanks Karl
|