Thanks for the formula. It works, and less work.

"T. Valko" wrote:

Try this:

Select the cells of interest: N7, N19, N31
Goto the menu FormatConditional Formatting
Formula Is:

=INDIRECT(ADDRESS(ROW(),COLUMN()))=MIN(N$7,N$19,N$ 31)

Click the Format button
Select the style(s) desired
OK out

Note: if all 3 of those cells are *empty* the format will be applied to all
3 cells. Post back if you need to account for that.

Biff

"Karl" wrote in message
...
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