I have tried numerous variants myself unsuccessfully so looking for some help.
Want to apply Condition format to B1 if A1= Cheque#0002, B2 if A2=Cheque#0003 and so on.
Also how many conditions can you have applied to any one cell in Excel 2010, and would the number per cell be the cause of the instability I am experiencing.
Many thanks in advance.
julhs
Last edited by julhs; 01-22-2012 at 02:21 PM.
Can you use the option to set conditional format using a formula with the formula:
=OFFSET(B1,0,-1)="Cheque#" & TEXT(ROW(B1)+1,"000")
If that's not what you're after it might be best if you posted an example workbook, so we can see what you're after.
why so many conditions,what do you ultimately want to achieve?if its to have each Cheque#xxxx a different colour then you probably will have problems afaik the number of formats limit in a workbook is "Conditional formats per cell -- Increased from 3 to available memory". that is vague but read here http://www.decisionmodels.com/memlimitsc.htm
but that aside say 60 diferent cf starts to look silly ,various shades very similar to each other whats thepoint?
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Hi
I can't understand .
Please Upload a sample file giving some examples of input and expected output
Regards
Mark the thread as solved if you are satisfied with the answer.
In your first post under the thread tools.
Mahju
I didn't think I explained it very well!!! Just want to colour fill B1 when A1= Cheque#?????
Then use a formula of:
=LEFT(A1,7)="Cheque#"
Andrew-R.
That was it, easy when you know how!
Have attached Dummy book for future ref.
Many thanks
julhs
thats not quite what you asked!
Sorry for the confusion, will upload a example book in any future posts.
julhs
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks