Need VBA for Conditional Formatting

r_nj

New Member
Joined
Nov 11, 2005
Messages
10
I would appreciate your HELP

I have the following table for which I can use Conditional formatting. But if I copy values into the table I lose the CF. I need a macro that I can run after copying values into the table based on the following criteria:
The cells containing highest 2 values in column A should be colored blue and the lowest 2 - red (lowest value should not include blanks or nulls). Same goes for columns B,D,E.

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 - grey
 

Some videos you may like

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,102
Office Version
  1. 365
Platform
  1. Windows
How are you copying the values into the table?

Does the table already have conditional formatting?
 

r_nj

New Member
Joined
Nov 11, 2005
Messages
10
Good Questions...
I tried pasting it as value and I did not loose the CF, Thanks. But a Macro would help.
 

Watch MrExcel Video

Forum statistics

Threads
1,119,272
Messages
5,577,133
Members
412,769
Latest member
VK12345
Top