sarahgeorge
11-13-2007, 12:59 AM
conditional formatting/highlight cell rules/equal to then insert the formula...
What formula do i require when i use conditional formatting that selects not only the word Pass followed by a space but then also any date?
ie. Pass 10/02/08 (but the date will change but the word pass will not change)
i need to be able to write any date and it will still select it
i have tried writing =Pass ##/##/## but this does not work
Or =Pass *
i need the wildcard for 2 numbers/2 numbers/2numbers
This should be the easiest thing if you know any code...but i can't work this out! ...and its driving me mad!
Can any one help me
Kind regards
Sarah
What formula do i require when i use conditional formatting that selects not only the word Pass followed by a space but then also any date?
ie. Pass 10/02/08 (but the date will change but the word pass will not change)
i need to be able to write any date and it will still select it
i have tried writing =Pass ##/##/## but this does not work
Or =Pass *
i need the wildcard for 2 numbers/2 numbers/2numbers
This should be the easiest thing if you know any code...but i can't work this out! ...and its driving me mad!
Can any one help me
Kind regards
Sarah