Conditional format B1 based on a specific word in A1 & calc
Closed
Sorrow81
Posts
3
Registration date
Thursday April 28, 2022
Status
Member
Last seen
May 3, 2022
-
Updated on Apr 28, 2022 at 04:00 AM
Sorrow81 Posts 3 Registration date Thursday April 28, 2022 Status Member Last seen May 3, 2022 - May 3, 2022 at 09:27 AM
Sorrow81 Posts 3 Registration date Thursday April 28, 2022 Status Member Last seen May 3, 2022 - May 3, 2022 at 09:27 AM
Related:
- Conditional format B1 based on a specific word in A1 & calc
- Word apk for pc - Download - Word processors
- How to search for a specific word on a website - Guide
- Number to text in word - Guide
- Word watermark on all pages - Guide
- Format factory - Download - Other
2 responses
Sorrow81
Posts
3
Registration date
Thursday April 28, 2022
Status
Member
Last seen
May 3, 2022
1
Apr 30, 2022 at 01:00 AM
Apr 30, 2022 at 01:00 AM
Hi Trowa, noted and thanks for your response, I'll look into your formula, yes it should B1*1.1, you're right. I also note your respond days, appreciate and thanks once again. :)
i'll try to see how to move about without using VBA (if possible), I don't think i even know how to use it haha.
i'll try to see how to move about without using VBA (if possible), I don't think i even know how to use it haha.
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Updated on Apr 28, 2022 at 11:46 AM
Updated on Apr 28, 2022 at 11:46 AM
Hi Sorrow81,
First the conditional formatting:
Select Column B, go to conditional formatting and choose to use a formula:
=ISERROR(FIND("INC VAL",A1))=FALSE
For the calculation:
Since it's not usual nor advised to put both a value and formula in the same cell; you have 2 options.
1. The default way: Use Column C for the formula: =IF(ISERROR(FIND("INC VAL",A1))=FALSE,(B1*0.1)*B1,"")
2. Column B contains both a number (I chose 999) and the calculation: ="999 " & IF(ISERROR(FIND("INC VAL",A1))=FALSE,(999*0.1)*999,"")
NOTE: It is not possible to place a number in a cell and let a formula replace that value. It can be done using VBA.
NOTE2: For calculation you say '10% multiplication'. Lets say the value is 100, then 10% would be 10 and the multiplication of that would be 1000. Not sure if that is what you meant. If you meant 10% addition then the part of the formula (could also be a translation thing as English is not my native language):
(B1*0.1)*B1
should be:
B1*1.1
Best regards,
Trowa
First the conditional formatting:
Select Column B, go to conditional formatting and choose to use a formula:
=ISERROR(FIND("INC VAL",A1))=FALSE
For the calculation:
Since it's not usual nor advised to put both a value and formula in the same cell; you have 2 options.
1. The default way: Use Column C for the formula: =IF(ISERROR(FIND("INC VAL",A1))=FALSE,(B1*0.1)*B1,"")
2. Column B contains both a number (I chose 999) and the calculation: ="999 " & IF(ISERROR(FIND("INC VAL",A1))=FALSE,(999*0.1)*999,"")
NOTE: It is not possible to place a number in a cell and let a formula replace that value. It can be done using VBA.
NOTE2: For calculation you say '10% multiplication'. Lets say the value is 100, then 10% would be 10 and the multiplication of that would be 1000. Not sure if that is what you meant. If you meant 10% addition then the part of the formula (could also be a translation thing as English is not my native language):
(B1*0.1)*B1
should be:
B1*1.1
Best regards,
Trowa
May 2, 2022 at 11:31 AM
May 3, 2022 at 09:27 AM