Is there a function in excel to test the text properties of a cell. ie. if
it's bold or red color text?
thanks
naveed010@hotmail.com
Is there a function in excel to test the text properties of a cell. ie. if
it's bold or red color text?
thanks
naveed010@hotmail.com
G0 to the Help files, and lookup
Cell worksheet function
That will give you a list of the types of formats that can be returned.
Mostly date, time and currency formats.
The only color return would be the "negative red" in currency.
What you're looking for needs code.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"NavEEd" <naveed010@hotmail.com> wrote in message
news:bOMcf.122058$Ph4.3743127@ursa-nb00s0.nbnet.nb.ca...
>
> Is there a function in excel to test the text properties of a cell. ie.
if
> it's bold or red color text?
>
> thanks
>
> naveed010@hotmail.com
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks