Forum

Notifications
Clear all

Conditional Formatting IF

3 Posts
2 Users
0 Reactions
55 Views
(@bogdan180205)
Posts: 2
New Member
Topic starter
 

I followed your advice and I post my issue on forum. I am a beginner with conditional formatting.

IF A1 contains the string "xc", then C1 = B1 + 5.

Of course, it must be done for all cells in column.

Thank you for help.

 
Posted : 08/05/2021 5:16 am
(@catalinb)
Posts: 1937
Member Admin
 

Salut Bogdan,

If you need to put a value in column C, that's not really a conditional formatting, it's a simple formula.

Try this formula in C1:
=IF(ISNUMBER(SEARCH("xc",A1)),B1+5,B1)

It will return B1 if the string is not found in A1.

 
Posted : 08/05/2021 2:49 pm
(@bogdan180205)
Posts: 2
New Member
Topic starter
 

The solution works perfectly. Thank you very much.

 
Posted : 08/05/2021 6:00 pm
Share: