I am trying to get conditional formatting in my excel 2007 to change the font color of cell b4 if there is any entry in b5. NOW B5 is a test field not numeric. I know how to do it if it was a numeric value. Here is what I am doing, I have B4 font color the same as the background so it does not show up. But I want it to change to black if field B5 has anything in it period. Again B5 is a text field not numeric.
=LEN($B5)>0
Would that work for you?
or =ISTEXT($B5)
or =$B5<>""
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
in B4 putto change the font color of cell b4 if there is any entry in b5
=B5<>""
so that would also need a conditional formatBut I want it to change to black if field B5 has anything in it period. Again B5 is a text field not numeric.
exactly what do you mean by
I know how to do it if it was a numeric value
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks