Conditional Formatting baseed on 2 values

%3CLINGO-SUB%20id%3D%22lingo-sub-1800931%22%20slang%3D%22en-US%22%3EConditional%20Formatting%20baseed%20on%202%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1800931%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20have%20a%20cell%20turn%20one%20color%20light%20green%20when%20a%20value%20is%20between%202%20cells%20and%20another%20color%20light%20blue%20when%20the%20value%20is%20between%202%20cells%20and%20%3D%20another%20cells%20value.%20In%20the%20attached%20I%20am%20trying%20to%20get%20cell%20E4%20to%20turn%20light%20blue%20when%20it%20is%20%26gt%3B%3D%20to%20cell%20E1%20and%20%26lt%3B%3D%20to%20cell%20I2%20and%20%3D%20to%20601%20in%20cell%20F4%2C%20otherwise%20I%20want%20it%20to%20turn%20light%20green%20when%20the%20value%20is%20%26gt%3B%3DE1%20and%20%26lt%3B%3D%20to%20I1.%20The%20goal%20is%20to%20have%20anything%20that%20runs%20on%20machine%20601%20turn%20light%20blue%20if%20the%20Job%20Start%20Date%20is%203%20weeks%20or%20less%2C%20or%20have%20it%20turn%20light%20green%20if%20it%20is%20any%20other%20machine%20where%20the%20date%20is%204%20weeks%20or%20less.%20I%20have%20tried%20a%20few%20options%2C%20but%20no%20luck.%20Please%20see%20attached.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1805089%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%20baseed%20on%202%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1805089%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F59469%22%20target%3D%22_blank%22%3E%40Scott%20Hetzel%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EScott%2C%20you%20may%20apply%20rule(s)%20as%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20664px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F228332i2041C6010899891E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EI%20didn't%20follow%20the%20logic%20literally%2C%20just%20to%20illustrate%20an%20idea.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1805247%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%20baseed%20on%202%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1805247%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F59469%22%20target%3D%22_blank%22%3E%40Scott%20Hetzel%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAdded%20the%20light%20green%20which%20I%20think%20was%20missing%20from%20Sergei's%20solution.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

I am trying to have a cell turn one color light green when a value is between 2 cells and another color light blue when the value is between 2 cells and = another cells value. In the attached I am trying to get cell E4 to turn light blue when it is >= to cell E1 and <= to cell I2 and = to 601 in cell F4, otherwise I want it to turn light green when the value is >=E1 and <= to I1. The goal is to have anything that runs on machine 601 turn light blue if the Job Start Date is 3 weeks or less, or have it turn light green if it is any other machine where the date is 4 weeks or less. I have tried a few options, but no luck. Please see attached.

 

thanks

6 Replies
Highlighted

@Scott Hetzel 

Scott, you may apply rule(s) as

image.png

I didn't follow the logic literally, just to illustrate an idea.

Highlighted

@Sergei Baklan 

@Scott Hetzel 

Added the light green which I think was missing from Sergei's solution.

Highlighted

@Bennadeau 

Yes, I didn't build all rules, only one to illustrate an idea how it could work.

Highlighted

@Bennadeau  Thank you so much it works good.

Highlighted

@Sergei Baklan  thank you Sergei, it worked out great.

Highlighted

@Scott Hetzel , you are welcome