Conditional format cell same shade as adjacent cell

Ironman

Well-known Member
Joined
Jan 31, 2004
Messages
865
Office Version
  1. 365
Platform
  1. Windows
Hi

I need to conditionally format cells in Column G so if the word OTHER appears in column B of the same row then the cell in Column G is shaded the same as the cell containing the word OTHER (which is RGB(197, 217, 241) or 12379352).

Many thanks!
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
66,064
Office Version
  1. 365
Platform
  1. Windows
Just select G2 downwards & use this formula
Excel Formula:
=B2="Other"
 

Ironman

Well-known Member
Joined
Jan 31, 2004
Messages
865
Office Version
  1. 365
Platform
  1. Windows
Wow, that was too simple, thanks a lot Fluff!
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
66,064
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback.
 

Ironman

Well-known Member
Joined
Jan 31, 2004
Messages
865
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

Apologies Fluff, I need a bit more help on this.

I need the grey-shaded cell to turn the same shade as Column B when Column B contains text = OTHER AND Column I either contains or starts with the word "walked"

This is the row (7575)

Sun, 16 Sep 2018OTHERJWalked 11.4 miles.


And this is the formula condition I've tried to use, which doesn't work
Excel Formula:
=AND(B7575 = "OTHER", $I$7575 = "Walked")

Thanks again!
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
66,064
Office Version
  1. 365
Platform
  1. Windows
Try
Excel Formula:
=AND(B7575 = "OTHER", LEFT($I$7575,6) = "Walked")
 
Solution

Ironman

Well-known Member
Joined
Jan 31, 2004
Messages
865
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

That works perfectly, many thanks Fluff!

Just another question - I can't get an exact match to the cell colour from the palette and I generated an 8 digit code for it (14610923) - could you please tell me how I can convert that back into an RBG colour I can see?
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
66,064
Office Version
  1. 365
Platform
  1. Windows
Select the cell with the colour you want & then on the home tab select the fill colour button, more colours, Custom & look at the RGB code.
 

Ironman

Well-known Member
Joined
Jan 31, 2004
Messages
865
Office Version
  1. 365
Platform
  1. Windows
Doh, lateral thinking in action! Thanks again Fluff and enjoy the rest of the evening.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
66,064
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback.
 

Forum statistics

Threads
1,148,369
Messages
5,746,295
Members
424,006
Latest member
Metal_warrior

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