To color excel cells in condition

[Sansar]

HI All,

I want to color cells if it is texted as ULF by green, if it is texted as OS by red in the all row down, it easy but I can't.
Any one help to do it I will appreciated to you.

Thanks,

San

 

[FDibbins]

You can do this with Conditional Formatting

1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select "format cells that contain"
4. change "cell value" to "specific text
5. enter the text

Repeat for the other criteria with a new rule

 

[Sansar]

Ford,

Thank you buddy for helped.

San