I know this has to be simple but for the life of me I can't figure it out today. I want a simple conditional format to check a cell and if the value is equal change the row colour to the fill colour selected. Can someple please tell me what I'm doing wrong. I have a testfile attached with an example for Completed and Hold that should colour fill Green for Complete, Yellow for Hold.
Sorry...incorrect solution., Don't check the file I attached.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
First delete the rules you have. Then
Select A2:F7, Conditional formatting>New Rule>Use Formula......
=$E2="Complete" format as Green
Conditional Formatting>New Rule>Use Formula
=$E2= "Hold" format as yellow
When working with Conditional formatting, fill in cell references as you would for the first cell in your range. Anchor any specific columns (i.e $E), and don't anchor things you want to be relative (i.e. row 2).
does that make sense?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Conditional Formatting > New Rule > Format only cells that contain > On the furthest left drop down, the default is "Cell Value". Select "Specific Text" instead. I think that's where you were having a problem. I re-attached your example. Is that what you were looking for?
This will work fine for just one cell however I would like that entire row to be highlighted according to that drop down choice.
Thx for taking time to look and respond!
Highlight the entire range you need the CF applied to - or adjust it to that range in the Applies To dropdownOriginally Posted by swalsh^s96
This will work fine for just one cell however I would like that entire row to be highlighted according to that drop down choice.
Thx for taking time to look and respond!
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I think I have this working now.
In the formula I have =$E1="Complete" and then applies to is: =$A:$G
I did see however this formula would change and make the $E1 goto some random # so I had to reapply. It seems now to have stuck so I will keep an eye on it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks