Cells that automatically change color

Odale

New Member
Joined
Mar 15, 2018
Messages
2
Hi !

I was wondering if anyone could help me.

I have provided an image, so illustrate what I mean.

Capture.PNG


As you will be able to see I have a column labelled PM - this column has the initials of project managers. When I enter the initials it will automatically fill in a color. This has been done by setting up a rule on "conditional formatting" so that whenever CMS is typed into the PM column it turns orange etc.

I am also wanting the Job no column to automatically change color, based on the color in the PM column. However I am having trouble doing this, as the there are no specific job numbers that are dedicated for each project manager - so I can't set up a condition for it (as far as I am aware, I could be wrong).

Can anyone please help.

Thanks,
Ollivia :)
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
if you look at the CF, you can adjust the formatting to extend across, just anchor the column with a $ and remove any $ that point to row =$A7
 

Odale

New Member
Joined
Mar 15, 2018
Messages
2
Thanks for answering. Please see the picture that includes the CF - would I place it at the end / at the start and how would it look?

Capture%201.PNG


Thanks
Ollivia
 

Forum statistics

Threads
1,137,354
Messages
5,681,002
Members
419,948
Latest member
Sbakker1

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