Excel - Macros - Coloring Cells

[r_nj]

I would like to get some help to create a macro as I have just joined a firm as a Jr. Analyst - I am still learning Macros - please help..

I would like to change the color of the cell based on the following:

For Column A,B,D,E,L : color highest 2 numbers- RED, lowest 2 numbers -yellow


For column C, if the % is 50% and above then green, if between 50.1% and 45% then blue, if lower than 44.9% then - black

 

[r_nj]

After trying the lowest number formula with CF it colored all the null cells - please help.

 

[Greg Truby]

<ul>[*]=AND((A1<=SMALL(MyRange,2)),NOT(ISBLANK(A1)))[/list]This would exclude blank (empty) cells from consideration. You'd need a different test if the "null" values you have are the result of formulas, for a nullstring will actually get counted among the LARGE values (odd thing that).

 

[r_nj]

Thank you!

 

[r_nj]

Thank you!

 

[mpierce]

Hi r-nj, thanks for posting this as I had a very similar question.

I am also a Jr. Analyst, are you working in the financial industry?

Good luck!