Hello. Can someone explain me how do I automatically make those cells (Title, Developer, Publisher, Japan) gray if Europe and America cells have Unreleased text?
i.hizliresim DOT com/26P5g2.jpg
Hello. Can someone explain me how do I automatically make those cells (Title, Developer, Publisher, Japan) gray if Europe and America cells have Unreleased text?
i.hizliresim DOT com/26P5g2.jpg
Try Conditional Format formula in E9 down:Formula:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
tbh I don't know what to do with that code
Select the data cells in column E and then click on the Conditional Formatting icon. Choose formula and put the formula in the box. Choose Format and pick a grey.
worked for some cells and didn't work for some, idk why. Thank you TMS for helping anyways.
Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Sure. Sorry for delay. I didn't expect further help.
As you can see it randomly fills cells gray. I want to fill Japan cells if EU and USA are "unreleased".
That will be because the sample data starts in row 12 whereas the image has the data starting in row 12.
Change the formula toFormula:Please Login or Register to view this content.
Still random cells are coloured regardless of EU and USA check
Untitled.jpg
Last edited by matz47; 02-16-2019 at 07:28 PM.
Yes, and that's because you have selected the entire column, not just the data cells. See my original response in post #2.
If you change the formula from row 9 to row 12, you need to specify row 12 down instead of 9 down.Try Conditional Format formula in E9 down:
Formula:Please Login or Register to view this content.
Okay, it works but works for only that cell lol. What about entire excel sheet? I could fill the only cell manually on my own anyways. I am looking for something to fill all of those cells that have same condition. For example 17, 23, 27th cells, they have same contidion.
Edit: "...17, 23, 27th cells..." fixed numbers.
Untitled.jpg
Last edited by matz47; 02-16-2019 at 08:07 PM.
Not sure how to explain E9 down or E12 down differently. Select cells in column E from E12 down to the last cell in column E that has data in it. With that range of cells selected, click on the CF icon and put the formula in.
https://support.office.com/en-us/art...b-f1951ff89d7f
Oh, sorry. Finally figured out. It works but if I select other colums (From B12 to E2959), it won't work. I want the entire lines get filled with gray.
Untitled.jpg
Change the column reference to be absolute...
Formula:Please Login or Register to view this content.
You're welcome. Thanks for the rep.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks