• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 74
  • Last Modified:

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

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
Ernesto
Asked:
Ernesto
  • 2
1 Solution
 
ProfessorJimJamCommented:
for x use =(B10>=(B11+2))  in conditional formatting

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

seee attached example.
Ejemplo.xlsx
0
 
ErnestoAuthor Commented:
Oh man!!!
so glad
tsm you experts
regards!!!!
0
 
ProfessorJimJamCommented:
you are welcome.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now