Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
custom format or conditional format?
Hi
I'm using Excel XP. I want to colour all the cells on a worksheet in green if the cells contain the word spare - the cells may also have other text as well as the word spare for eg. spare 09:00 or spare 15:30. I can't seem to work out how to do this using conditional formatting - is there a way to write a custom format to do this? Any help really appreciated. Anita |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
custom format or conditional format?
=LEFT(A1,5)="spare" would be the formula you apply in the conditional format
dialogue box to test if the 5 left most characters show "spare" This of course assumes that "spare" will always be on the left hand side of the cell contents. Dave -- Brevity is the soul of wit. "Anita" wrote: Hi I'm using Excel XP. I want to colour all the cells on a worksheet in green if the cells contain the word spare - the cells may also have other text as well as the word spare for eg. spare 09:00 or spare 15:30. I can't seem to work out how to do this using conditional formatting - is there a way to write a custom format to do this? Any help really appreciated. Anita |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a conditional format that changes the number format | Excel Discussion (Misc queries) | |||
Custom Format for User Defined Function | Excel Discussion (Misc queries) | |||
Copy & paste conditional format | New Users to Excel | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Conditional Format - 3 conditions | Excel Worksheet Functions |