I am trying to figure out how to highlight entire rows within a spreedsheet based on the information in a cell. I have gone to the conditional formatting and done:
=$A4="Needs Labs" and formatted that red, but when i go to note what areas it applies to, It will not highlight the row. I use the wizard box to decide where to apply the formatting like I saw on an online tutorial and dragged across the row, but nothing happened.
Ant help would be appreciated.
Hard to say where you are going wrong without seeing what you have done
1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =$A4="Needs Labs"
Make sure that the text in A contains that exact string in a cell.
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 did exactly as you said and it worked this time for the row-Thanks. When I tried to drag it down to cover the sheet though I received a bunch of filled in fields that should have been empty? Do I have to do this for each row, or should I have ranged the entire page?
I expanded the range and it works, thank you.
you'r welcome, and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks