Vlookup table Formula and IF formula help

[Minty5490]

Hi,

I am using a vlookup formula. Which works well to pull data from my other sheet. But I want it to just pull the colour only from the cell

Example: Data (jan) from cell a1 is a Blue colour, and has a number example 5. Vlookup sheet (e4), overwrites from the information of the data sheet with the number, but not the colour? I only want the colour and keep the information already in the cell on the vlookup sheet e4.

Formula I am using: =VLOOKUP($E$4,Jan,3,1)

Can anyone help, not sure if I need to put a If or AND, but how?

Thanks

 

[DanteAmor]

What you are trying to do can not be done with formulas or conditional formatting.
---
For its operation, only one macro is needed in the "Calendar Year" sheet.
Remove the macro that you put.

Enter the macro of the sheet "Calendar Year" and in this line you have to put the range of the cells of March,

meses = Array("E8:I14", "K8:O14")       'add range for each month

eg.

meses = Array("E8:I14", "K8:O14", [COLOR=#ff0000]"Q8:U14"[/COLOR])       'add range for each month

And so you continue with the other months.

 

[DanteAmor]

Also, you must put each month in each column

 

[Minty5490]

Hi Dante,

I have look through again at you test. I have got it working and understand it now.

Many thanks for you help, it works fantastic. Sorry to be such a pain. Much appreciated. thanks

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.