Conditional Formula needed

[ironsides]

Formula need for Conditional Format


Cell Value is Equal to "si" color red, "sm" color dark green

Thanks

 

[VoG]

Try like this

Excel Workbook
	A
1	si
2	sm
3	sa
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	1. / Formula is =A1="sm"	Abc
A1	2. / Formula is =A1="si"	Abc

 

[T. Valko]

Formula need for Conditional Format


Cell Value is Equal to "si" color red, "sm" color dark green

Thanks

Try this...

• Select the cell in question. Let's assume this is cell A1.
• Goto the menu Format>Conditional Formatting
• Condition 1
• Select the Formula Is option
• Enter this formula in the box on the right:

=A1="si"

• Click the Format button
• Select the desired style(s)
• OK
• Click the Add button
• Condition 2
• Select the Formula Is option
• Enter this formula in the box on the right:

=A1="sm"

• Click the Format button
• Select the desired style(s)
• OK out

 

[ironsides]

Formula need for Conditional Format


Cell Value is Equal to "si" color red, "sm" color dark green

Thanks

Thank you VoG and T Valko.

 

[T. Valko]

Thank you VoG and T Valko.

You're welcome!