Recent content by henksss

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