?
Solved

i need if the cell above or bellow is upper +2 colored

Posted on 2016-09-01
3
Medium Priority
?
66 Views
Last Modified: 2016-09-02
Hi you guys
is any way for colored a cell if the diferences between x and y  are 2 or more?

regards you guys

im attach an exel file
Ejemplo.xlsx
0
Comment
Question by:Ernesto
  • 2
3 Comments
 
LVL 27

Accepted Solution

by:
ProfessorJimJam earned 2000 total points
ID: 41780773
for x use =(B10>=(B11+2))  in conditional formatting

for y use =((B10+2)<=B11) in condtional foramtting

seee attached example.
Ejemplo.xlsx
0
 

Author Closing Comment

by:Ernesto
ID: 41780929
Oh man!!!
so glad
tsm you experts
regards!!!!
0
 
LVL 27

Expert Comment

by:ProfessorJimJam
ID: 41781331
you are welcome.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question