Color Fill - Please Help!

wswapp

New Member
Joined
Jan 13, 2016
Messages
4
I want to color fill the name "Billy" in cell 1A automatically only after cell 1C, 1D, 1E is fill with a symbol check mark.

Thank you,
William
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
Do a conditional formatting in cell A1, and use an "AND" formula to reference all the cells that need a check mark...

On Cell "A1", do the following:
1. On the Conditional Formatting options, choose "New Rule..."
2. Use the last option: "Use a formula to determine which cells to format"
3. Use the following equation: =AND(C1 = "blah", D1 = "blah", E1 = "blah") ---NOTE--- instead of "blah", enter whatever you use to identify the cell as being checked.
4. Edit the format however you'd like.
 
Upvote 0
If I use a check mark symbol in the cell, what should I type in the formula cells format to tell it was a check mark symbol?

I was able to make it work by using "yes" in the format.

Thank you so much!
William
 
Upvote 0
After the name is highlighted is their a way Excel can generate the current date on a different cell box F1 also highlight after the C1,D1,E1 was filled.

Can you link a highlight cell on one excel file, so it can appear in another excel file with the same name. So, when the fill color is done one one file I want my other file to be highlighted at the same time (link), is that even possible?

Thank you,
William
 
Upvote 0
As you get into further customizations, it becomes more difficult to create with normal Excel features without going into VBA. You had a variety of questions, and they are all easily possible to do if you create the code in VBA.
 
Upvote 0

Forum statistics

Threads
1,223,098
Messages
6,170,103
Members
452,302
Latest member
TaMere

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
Back
Top