Auto color based on another cell color

awaltz

New Member
Joined
Aug 17, 2021
Messages
2
Office Version
  1. 2016
Platform
  1. Windows
Hello, I am stumped and looking for assistance as I am not the greatest at Excel.

The box on the left side has conditional formatting colors based on the value of the numbers. The box on the right is only letters.

I am looking to always have the cell color in the box on the right, to be the same as the box on the left (based on those conditional formats).

The data on both sides can change, but as long as the coloring is exactly the same on both sides then my work will be complete. Does anyone know the best way for me to edit the cell color on the right side to change and basically always clone those on the left?
Thanks!
Excel Colors.png
 

Attachments

  • Excel Colors.png
    Excel Colors.png
    26.4 KB · Views: 3
  • Excel Colors.png
    Excel Colors.png
    26.2 KB · Views: 3

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

etaf

Well-known Member
Joined
Oct 24, 2012
Messages
5,114
Office Version
  1. 365
Platform
  1. MacOS
add another conditional formatting rule, with the same rule

So select K2:Q11

then add the rules

if you post the spreadsheet here using XL2BB - see menu or my signature

What rules are you using for the colours in B to H ?

lets say dark green is if B2 is greater or equal to 20%
that would be B2>=0.2

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
K2:Q11

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=B2 > = 0.2

Format [Number, Font, Border, Fill] Format fill Dark Green
choose the format you would like to apply when the condition is true
OK >> OK

Repeat for all the other colours

Otherwise you will have to use VBA , not my area
 
Solution

awaltz

New Member
Joined
Aug 17, 2021
Messages
2
Office Version
  1. 2016
Platform
  1. Windows
Yes! This worked!

I will add that I did have to include in the formula to format if a number is between. An example I used was =AND(B2>=.1,B2<=0.2).

Now when the values and colors change on one side, the other automatically does exactly the same as well.

I'm glad too also avoid VBA. Thanks much!
 

etaf

Well-known Member
Joined
Oct 24, 2012
Messages
5,114
Office Version
  1. 365
Platform
  1. MacOS
you are welcome
 

Forum statistics

Threads
1,148,250
Messages
5,745,638
Members
423,965
Latest member
visionquest1972

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top