Greetings,
I have a formula which is looped down column A and another formula that is looped down column B. I'm trying to figure out how to highlight the entire row yellow if a cell is nonempty in column A and highlight the entire row red if a cell is nonempty in column B. Here is my code:
Any help is much appreciated.
Please Login or Register to view this content.
Well, if you want to change the color if the cell is empty, then the <> need to become =. e.g.
To set an entire row, you would do something like thisPlease Login or Register to view this content.
Please Login or Register to view this content.
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
That did the trick! Thanks!
Please Login or Register to view this content.
Maybe:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks