M
Mike McLellan
How do I set the background colour of a cell to Red if the value of any cell
in a range is greater than, say, 110?
in a range is greater than, say, 110?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Stefi
Use this formula:
=COUNTIF(A1:A10,">"&110)>0
Adjust range!
Regards,
Stefi
„Mike McLellan†ezt Ãrta:
=COUNTIF(A1:A10,">"&110)>0
Adjust range!
Regards,
Stefi
„Mike McLellan†ezt Ãrta:
J
Jacob Skaria
1. Select the cell/Range say Column A...
2. From menu Format>Conditional Formatting>
3. For Condition1>Select 'Cell Value Is' ' 'Greater than' and enter 110
4. Click Format Button>Pattern and select your color (say Red)
5. Hit OK
If this post helps click Yes
2. From menu Format>Conditional Formatting>
3. For Condition1>Select 'Cell Value Is' ' 'Greater than' and enter 110
4. Click Format Button>Pattern and select your color (say Red)
5. Hit OK
If this post helps click Yes
M
Ms-Exl-Learner
Try this.
1. Select the range
2. From menu Format>Conditional Formatting>
3. For Condition1>Select 'Cell Value Is' and Select ‘Greater than’ from the
Ccondition drop down and in the next field type 110
4. Click Format Button>Pattern>Color select 'red' then give ok
If this post helps, Click Yes!
1. Select the range
2. From menu Format>Conditional Formatting>
3. For Condition1>Select 'Cell Value Is' and Select ‘Greater than’ from the
Ccondition drop down and in the next field type 110
4. Click Format Button>Pattern>Color select 'red' then give ok
If this post helps, Click Yes!
S
Stefi
You and Jacob didn't observe that the condition is "ANY cell in a range"!
Stefi
„Ms-Exl-Learner†ezt Ãrta:
Stefi
„Ms-Exl-Learner†ezt Ãrta:
M
Mike McLellan
Thanks, Stefi - just what I needed!
Stefi said:Use this formula:
=COUNTIF(A1:A10,">"&110)>0
Adjust range!
Regards,
Stefi
„Mike McLellan†ezt Ãrta:
M
Ms-Exl-Learner
Hi Stefi,
I think the answer provided by Mr. Jacob and by myself is right. In my post
i have clearly mentioned that select the range before applying the
conditional formatting.
I think the answer provided by Mr. Jacob and by myself is right. In my post
i have clearly mentioned that select the range before applying the
conditional formatting.
S
Stefi
The question was "... set the background colour of a cell ... if the value
of any cell
in a range ...". For me it means to set the color of ONE cell depending on
the values of several cells. Yor solution sets the color of a range of cells
depending on the cells own values. The OP shared this interpretation!
Regards,
Stefi
„Ms-Exl-Learner†ezt Ãrta:
of any cell
in a range ...". For me it means to set the color of ONE cell depending on
the values of several cells. Yor solution sets the color of a range of cells
depending on the cells own values. The OP shared this interpretation!
Regards,
Stefi
„Ms-Exl-Learner†ezt Ãrta:
S
Stefi
You are welcome! Thanks for the feedback!
Stefi
„Mike McLellan†ezt Ãrta:
Stefi
„Mike McLellan†ezt Ãrta:
D
David Biddulph
I think that you'll find that Stefi has done rather more "MS-Exl-Learning"
than you have. Your condition will turn the cell red only if the content of
THAT PARTICULAR CELL is greater than 110. The OP said that the requirement
was to turn the cell red if the value of ANY CELL IN THE RANGE is greater
than 110.
than you have. Your condition will turn the cell red only if the content of
THAT PARTICULAR CELL is greater than 110. The OP said that the requirement
was to turn the cell red if the value of ANY CELL IN THE RANGE is greater
than 110.
J
Jacob Skaria
Sorry I misread the post..
Stefi/Mike
Just the below will do as conditional formatting returns true only if the
below formula returns more than 0.
=COUNTIF(A1:A10,">110")
If this post helps click Yes
Stefi/Mike
Just the below will do as conditional formatting returns true only if the
below formula returns more than 0.
=COUNTIF(A1:A10,">110")
If this post helps click Yes
M
Ms-Exl-Learner
Mr. Stefi & Mr. David thanks for both of you for indicating my mistake. In
fact I didn’t notice the word “IN A RANGE IS GREATER THANâ€. After seeing
both of your replies, I come to know that my post is not suitable for the
question.
Anyway thanks for guiding & suggesting me about my mistake…
fact I didn’t notice the word “IN A RANGE IS GREATER THANâ€. After seeing
both of your replies, I come to know that my post is not suitable for the
question.
Anyway thanks for guiding & suggesting me about my mistake…
S
Stefi
I like when misunderstandings get settled.
Stefi
„Ms-Exl-Learner†ezt Ãrta:
Stefi
„Ms-Exl-Learner†ezt Ãrta:
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.