View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default 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