Formula, Conditional Formula Needed
You're welcome!
Biff
"FC" wrote in message
...
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
|