I have a conditional formula which populates a string depending on the value selected by user.
E.G of formula is:-
=IF($B$1=0,"CONTACT PERSON - OPTIONAL",IF($B$1=5,"CONTACT PERSON - MANDATORY",""))
Where the result is "CONTACT PERSON - MANDATORY" then I want the word MANDATORY (not the whole string) to be displayed in RED.
Is this possible. Please Help
Thanking you in advance.
Rgds
Dhiresh
This is the third thread of yours that I've seen on this topic - please do not multi-post.
Pete
Hi Pete,
had Run-Time error each time I saved the thread so was not sure if the Thread was created.
Sorry for the duplicates
Will make this solves
Duplicate caused due to system issues.
Thread closed.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks