Hey there,
First hope I am posting this in the right section sorry if not.
Is there a way to use conditional formatting to check column A and if it comes across text that is bolded to highlight row?
thanks for your time.
Hey there,
First hope I am posting this in the right section sorry if not.
Is there a way to use conditional formatting to check column A and if it comes across text that is bolded to highlight row?
thanks for your time.
Last edited by devilchild99; 09-12-2013 at 01:28 AM.
If you are trying to see if any text in a cell is bolded, then the short answer is - excel cannot "see" colors or fonts, these are formats, not data, and excel only works with/sees data.
So regular CF will not be able to "see" is a cell has red text, bolded text, underlined text etc, you will need some0ne to put some VBA code together for this
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
Ahh ok thank you for the reply, is there a way to remove this question from this section and I will ask over in VBA section if any one is able to lend a hand?
I will move it there for you
heh, thanks did not know you could i created a new one figured i could delete this one
Nope, I have closed the other 1 for you, you can continue here
If your bold formatting is on the entire cell, try this:Place it in a module of a workbook (preferably PERSONAL workbook), and run the macro.Please Login or Register to view this content.
*Thumbs up* thank you very much.. excellent vba
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks