PDA

View Full Version : Conditional formatting formula required for excel



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

Aussiebear
11-13-2007, 02:25 AM
Sarah, I believe the string "Pass" would need to be placed inside quotation marks. Could you tell us mre about the value "Date" How is this arrived at? Will it be the current date or one that the user decides?

Bob Phillips
11-13-2007, 02:50 AM
You are mixing up so many things here. You headline it as conditional formatting, give an example of a display format, and talk about code.

What exactly do you wan t to do?

is this a continuatiuon of your previous question? Did that resolve satisfactorily?

anandbohra
11-13-2007, 02:55 AM
go to conditional formatting & select there formula is
say the word "pass 13/11/2007" is in cell B1
so your condition will be formula is =left(b1,4)="Pass"
& set the desired formatting for true

sarahgeorge
11-13-2007, 11:09 AM
Sorry, i needed a quick answer and i can't quite communicate it to you in programming terms very well so i thought that i would break it up into smaller chunks to get an answer.

yes i would write ="Pass" in quotes, but also a user decided date next to the word pass, ie. ="Pass 02/03/07" where the date keps changing

Norie
11-13-2007, 11:17 AM
Sarah

How about just =LEFT(A1, 4)="Pass"?

Bob Phillips
11-13-2007, 12:43 PM
There is no date validation function but you could test it fo a number

=AND(LEFT(K1,4)="Pass",ISNUMBER(--RIGHT(K1,LEN(K1)-5)))