Macro conditional format

[lasher18]

Hello again guys, I hope it is going good.

I am currently setting up a vacation assignment workbook for my team and would like to highlight some cells based on a value. See the attached screenshot.
I would like to highlight cells "V" in green when their count is not greater than the value in column NN. Thus, when the number of "V" exceeds the value in the NN column, the additional V will be highlighted in red.

Thanks for helping once again,
AM

[PCI]

What do you mean by

to highlight cells "V" in green

Which column is it ? Is it column "NL", if yes then quite all cells are red, is not it ?

[lasher18]

for example, for "alashera" he has 1 vacation day that he does not need to wait for approval ("V" should appear in green), but he will have to request the other 3 days ("V" in red). The red "V" should appear if the number of "V" in each employee's row is greater than the value in the "NM" column.
I'd like to have this proccess automated for each employee.

Thanks

[lasher18]

Hi,
I'm just looking for the structure of the code in VBA. I know it could be something with loops comands and If and For functions, but I do not know how to structure the code.
It would be appreciated some help

Regards,

[PCI]

See here a short piece of code which could work .... not completely tested because there is conditional format and therefore the color fill is not seen
Why don't you use a conditional format formula to do what you expect ...?

Please Login or Register  to view this content.

[lasher18]

Hi,
it works really well your solution! but how can I do it with conditional format?
Could we have the code identify the cells in order? in the sense that the cells that are modified first (appear in green) take precedence over those that are modified later (in red). The macro modifies in order and does not have this preference.
but if you consider the condicional format would be better let me know


Thank you for your help :D

[lasher18]

hey,
do you know how can I do it with conditional format?

Thanks

[PCI]

I started to do it but the copy-paste of the conditional format does not work properly, therefore it must be prepared for each cell.
That is where I am today, it seems difficult to use it right now.

[lasher18]

Ok, good, could you tell me in what way are you doing it? can you put an example and I'll try it by my own

Thanks