I think an easy Conditional Formatting ?
in [General]
|
Prev: Can't save Excel file. Msg "File" is in use. Try again later.
Next: TRUE: Would like it to appear as "True" in the cell.
From: Scott on 23 Feb 2010 12:57 I'm trying to write a Conditional Formatting formula for cell C11, if the number in Cell A10 is greater than 1. I've been trying this without getting the results that I want: =A10>=1 This formula will fill cell C11, however when value in A10 is removed, C11 still remains with that fill, when I want it to be unformatted. Any ideas? Thanks
From: Fred Smith on 23 Feb 2010 13:51 What do you mean by "removed"? If you delete the contents, then c11 should change to unformatted. However, if you "remove" the cell by entering a space, then the conditional format will apply because a space is greater than 1. Clear the contents of the cell, or use "" as the value, then the conditional format will not be triggered. Regards, Fred "Scott" <Scott(a)discussions.microsoft.com> wrote in message news:9A6AE0BF-C378-4C67-8023-E7683D96615A(a)microsoft.com... > I'm trying to write a Conditional Formatting formula for cell C11, if the > number in Cell A10 is greater than 1. > > I've been trying this without getting the results that I want: > =A10>=1 > > This formula will fill cell C11, however when value in A10 is removed, C11 > still remains with that fill, when I want it to be unformatted. > > Any ideas? > > Thanks >
From: Pete_UK on 23 Feb 2010 13:49 Try this formula instead: =AND(A10<>"",A10>=1) Hope this helps. Pete On Feb 23, 5:57 pm, Scott <Sc...(a)discussions.microsoft.com> wrote: > I'm trying to write a Conditional Formatting formula for cell C11, if the > number in Cell A10 is greater than 1. > > I've been trying this without getting the results that I want: > =A10>=1 > > This formula will fill cell C11, however when value in A10 is removed, C11 > still remains with that fill, when I want it to be unformatted. > > Any ideas? > > Thanks
From: Russell Dawson on 23 Feb 2010 14:07 Scott, it seems ok. Have you any other formatting that may be interfering with the cell? -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "Scott" wrote: > I'm trying to write a Conditional Formatting formula for cell C11, if the > number in Cell A10 is greater than 1. > > I've been trying this without getting the results that I want: > =A10>=1 > > This formula will fill cell C11, however when value in A10 is removed, C11 > still remains with that fill, when I want it to be unformatted. > > Any ideas? > > Thanks >
From: Scott on 23 Feb 2010 14:21
No, I shouldn't. I figured it out though. This works: =AND($A10>0,$A10<=1500) "Russell Dawson" wrote: > Scott, it seems ok. Have you any other formatting that may be interfering > with the cell? > -- > Russell Dawson > Excel Student > > Please hit "Yes" if this post was helpful. > > > "Scott" wrote: > > > I'm trying to write a Conditional Formatting formula for cell C11, if the > > number in Cell A10 is greater than 1. > > > > I've been trying this without getting the results that I want: > > =A10>=1 > > > > This formula will fill cell C11, however when value in A10 is removed, C11 > > still remains with that fill, when I want it to be unformatted. > > > > Any ideas? > > > > Thanks > > |