Cell color based on adjacent value

How do I apply the color style of Bad, Good, Neutral to adjacent cell based on a value.

Please see attachment.
C--Users-lfreund-Downloads-COLORS.xlsx
LUIS FREUNDAsked:
Who is Participating?
 
ShumsDistinguished Expert - 2017Commented:
Hi Luis,

Check in sheet 2, you need to apply 3 different conditional formatting for the same range as below:
Multiple Conditional FormattingC--Users-lfreund-Downloads-COLORS.xlsx
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You can make new rules for conditional formatting using the formulas as shown in the attachment for each color.
To do so, select the whole column A --> Home Tab --> Conditional Formatting --> New Rule --> Use a formula to determine which cells to format --> type the relevant formula in the formula box --> Format --> Set the format as per your choice.
C--Users-lfreund-Downloads-COLORS.xlsx
0
 
LUIS FREUNDAuthor Commented:
THANK YOU!
1
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.

All Courses

From novice to tech pro — start learning today.