Formula, Conditional Formula Needed
Thanks for your reply. You are correct as to Office 2007 and, yes, I have
tried it and it works beautifully. As I said, all three cells are colored if
all three are empty.
Bob M.
"T. Valko" wrote:
I don't know. It looks like these are steps from Excel 2007. I don't have
Excel 2007. Did you try it and it works? Is it acceptable if all the cells
are empty then they get colored?
Biff
"robert morris" wrote in message
...
To all the experts. I am a beginner however would rhere be any thing
wrong
with the following?
Conditional Formating Use Formula to Determine which cells to format
=N7=MIN($N$7,$N$19,$N$31) OK
Applies to =$N$7,$N$19,$N$31
Format Color Fill with Color of Choice
If all cells are blank, all will be colored. If only one cell has a
value,
it will show color
Bob M.
"FC" wrote:
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
|