Search results

to SIRJB7, YOU WROTE, "Reading more carefully your question, I'm afraid that it isn't possible to do that with conditional formatting, as CF only formats (font, style, color, background, etc.) and doesn't change values." Thanks for that info it helped me to stop looking for cf formula and I...

Thanks SirJB7 thats a shame that cf can't do it. Could you help me with the VB code i could enter in VB? The code for VB that I used in excell 2003 was as follows. Private Sub Worksheet_Deactivate() Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target...

Can conditional format in excel 2010 return a cell reference like "A1" instead of a cell value if a criteria is met, if so what would be the formula? Say cell A1 value is 5 and cell A3 is also 5 can A3 have a conditional format formula that will change the A3 value of 5 to reference "A1"...

Hi my name is Henk and I'm in Melbourne. I was wondering now that I have Office 2010 whether I can do a conditional format to compare a range of cells that have all different values in them to a row of 15 cells. Range being C14:G150 and Row being M4:X4. If a cell in the range is the same number...

Sorry SirJB7 Thanks for the advise I'm fairly new here not sure how to start new topic will look into it. However having said that I tried your formula but doesn't work, nothing happens. Regards Henk

Hi my name is Henk and I'm in Melbourne. I was wondering now that I have Office 2010 whether I can do a conditional format to compare a range of cells that have all different values in them to a row of 15 cells. Range being C14:G150 and Row being M4:X4. If a cell in the range is the same...

It seems to be working fine. I was wondering if it can be set up without the 2 buttons to colour and clear. It should auto clear when there is no data in C:I. and autofill as soon there is data and colour conditions are met. I also need to copy this VB to another original spreadsheet and...

Thank you and have a good fathers day too. Regards Henk

Hi Narayank991 Thanks so much for your help. Every time I add data to a row I would like the colours to affect the cells as well, if that is possible?

Thanks Narayank991 that is looking quite good and almost done but if I enter numbers in the future in cells d364,e364...k364 and onwards, it will give me the results in L,M364 but no colour changes. Also in all the ones where there is colour now, I can remove the colours by clearing them...

Aaaah I found it as well as yours is the right one Thanks so much. here is the link to get my file. Hope some one can help solve this one https://dl.dropbox.com/u/101518911/conditional%20format%20vb.xls Regards Henk

do you have a copy you can send back to me?

my file is gone. Its all too hard All your link does open excel with nothing in it.

I went to open the uploaded file but there is nothing there the file is gone.

https://dl.dropbox.com/u/101518911/conditional%20format%20vb.xls This is my spreadsheet with explanations in there Hope someone can help. Regards Henk

Thanks Sirjb7 I will try that. regards Henk

Hi I want to upload but not sure where as I tried it before and was unsuccessful. Regards Henk

Thanks for your advise, I take this onboard as good advise. I was actually wondering if my first post didn't get posted. I therefore thought I would try it again. I was getting very prompt reply initially and as it slowed somewhat thought there could be something wrong with my posting. I...

If L=0 and M=0 then (ignore it) If L=0 and M=1 then (ignore it) If L=0 and M=2 then (ignore it) if L=1 and M=1 then (ignore it) if L=2 and M=1 then (ignore it) if L=3 and M=0 then (ignore it)

Can someone help? What I need is this conditional format; in excell 2003 if(and(L3:L1000=1,M3:M1000=2),format colour blue in both columns L,M if(and(L3:L1000=2,M3:M1000=2),format colour blue in both columns L,M if(and(L3:L1000=3,M3:M1000>0),format colour green in both columns L,M...

Hi thanks for your good question If L=0 and M=0 then (ignore it) If L=0 and M=1 then (ignore it) If L=0 and M=2 then (ignore it) if L=1 and M=1 then (ignore it) if L=2 and M=1 then (ignore it) if L=3 and M=0 then (ignore it) I have these results pretty well ignored with my original message,

Can someone help? What I need is this conditional format; in excell 2003 if(and(L3:L1000=1,M3:M1000=2),format colour blue in both columns L,M if(and(L3:L1000=2,M3:M1000=2),format colour blue in both columns L,M if(and(L3:L1000=3,M3:M1000>0),format colour green in both columns L,M...

What I asked for now works but what I have asked for is not exactly what I need. What I need is this conditional format; in excell 2003 if(and(L3:L1000=1,M3:M1000=2),format colour blue in both columns L,M if(and(L3:L1000=2,M3:M1000=2),format colour blue in both columns L,M...

Thanks Deb. I was wondering if I want the column next to it to also change colours do i paste it twice and change the column identification? For Each c In Sheets(""enter results").Range("m3:m1000")

How can I select different colours for the numbers?