I have a spreadsheet file for my monitoring of shipments from abroad and I was hoping someone could help me out for what am trying to do. I have attached a simple workbook.
1. Is it possible to highlight cell A (light Green) if put the word "closed" in cell Y
2. Is it possible to highlight cell A (light Red) if put the word "OPEN" in cell Y
Yes. You need to set up two conditional formatting rules using these fromulae:
=$Y2="CLOSED" - set the cell fill to green
=$Y2="OPEN" - set the cell fill to red
Copy the formatting to other cells whose colour needs to change.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Dear AliGW,
Can you put these formula to my sample attachment?
Try it yourself first. If you don't, you won't learn anything.
I have tried it already and still nothing happen in Cell A
As Ali suggested.
Select the whole date and then press ALT->O->D, you will get a window naming conditional formating rule manager -> click on new rule you will get new formatting rule->select the last option called use as formula to determine which cells to format-> put =$Y2="CLOSED" this formula into format values where this formula is true-> now click on format and format cells as you want then apply and then ok.
Now the conditional formatting will work.
Check the attached file.
Attached Files Attached Files
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
See the attached.
If your problem is now resolved, please mark the thread as SOLVED and consider thanking those who have helped you.
That was exactly what i did.. shukla.ankur281190
Please try to put the word "Closed" in Cell Y10 and if Cell A10 highlighted the desired color. then i must say it's done.
Not yet..
Please try to put the word "Closed" in Cell Y10 and if Cell A10 highlighted the desired color. then i must say it's resolved or done.
You need to copy the formatting to those cells. We have shown you how to create the formatting.
Select the whole row no 2 then copy that one, now select the whole data where you need conditional formatting then go to paste special and select formatting then ok.
Hope this will help you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks