Conditional format B1 based on a specific word in A1 & calc
Sorrow81
Sorrow81
- Posts
- 3
- Registration date
- Thursday April 28, 2022
- Status
- Member
- Last seen
- May 3, 2022
Sorrow81
- Posts
- 3
- Registration date
- Thursday April 28, 2022
- Status
- Member
- Last seen
- May 3, 2022
Related:
- Conditional format B1 based on a specific word in A1 & calc
- Excel conditional formatting if another cell contains specific text ✓ - Forum - Excel
- Conditional format based on another cell containing text - Forum - Excel
- Excel conditional formatting formula based on another column ✓ - Forum - Excel
- Conditional formatting a cell if a certain word is met ✓ - Forum - Excel
- Highlight cell if another cell contains any text ✓ - Forum - Excel
2 replies
Sorrow81
Apr 30, 2022 at 01:00 AM
- Posts
- 3
- Registration date
- Thursday April 28, 2022
- Status
- Member
- Last seen
- May 3, 2022
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
Updated on Apr 28, 2022 at 11:46 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
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