Conditional Formatting in MS Excel

  Gary Wood 09:34 28 Oct 05
Locked

I am creating a in which I want the background of a cell to be conditionally formatted to turn green when the cell contents begin with certain text but are followed by any other text.

For example, I want all cells that being with "sample" to be highlighted green, regardless of whether the cell says "sample 1", "sample 2" or "sample X".

Can anyone tell me how to do this? I'm using Excel 2000 and tried entering conditional formatting of cell value = "sample *" but this doesn't work.

  VoG II 09:50 28 Oct 05

Select Formula Is on the drop-down then enter a formula like:


=LEFT(A1,6)="Sample"

  Gary Wood 10:06 28 Oct 05

Many thanks VoG.
That worked perfectly. Just out of interest, where did you get this formula from? I spent a long time looking at help files and searching the internet before posting!

Thanks,

Gary

  VoG II 10:16 28 Oct 05

If you click on 'fx', and select the Text category you should find it.



If you click here and scroll right to the bottom you can download an excellent Excel Function Dictionary.

This thread is now locked and can not be replied to.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

1995-2015: How technology has changed the world in 20 years

These are the Best Christmas Ads and Studio Projects of 2016

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…