LinkBack URL
About LinkBacks
Hello,
is it possible to use conditional formatting to fill a cell with text?
Ex) if cell a1 contains the word "float", i want conditional formatting to put "fl" in b1
thank you in advance for your help !!!!
Hello,
is it possible to use conditional formatting to fill a cell with text?
Ex) if cell a1 contains the word "float", i want conditional formatting to put "fl" in b1
thank you in advance for your help !!!!
Hi,
Not with conditional formatting. Formatting, conditional or otherwise can't change anything in the underlying cell, merely present it in a different way.
You could use in B1
Formula:
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hello and thanks for quick reply,
Both A1 and B1 contaion a drop list. But I would like B1 to to change to "float" everytime "float" is selected in A1.
What I would like is for B1 to automatically select "float", if it is selected in A1. I cant use formulas because they get erased when a selection is made from the drop list.
Hi,
You can only do this with a macro - see attached.
If you want to force B1 to read "float", why do you need B1 to also have a drop down?
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
Thanks for the help, but what Im looking for needs to be duplicated hundreds of times
Last edited by MICHAEL BIZ; 11-21-2015 at 03:00 PM.
This is a poker dealer rotation and I need the user to be able to input what table the dealers are dealing throughout the shift
If "FL"is selected, then I would like the rest of the shift to change to "FL", but still contain the drop list in case the dealer has to go back to work.
I have attached part of the file so maybe it will make more sense, thanks again for the help
online example.xlsm
Last edited by MICHAEL BIZ; 11-21-2015 at 03:32 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks