Fill Color if Cell meets condition of another cell

**RobIzq** · 07-30-2015, 10:16 AM

Good Morning Friends

My name is Robert and this is my first time posting on these wonderful forums. I have perused through these forums many times to develop macros but this one has me stumped. Perhaps it cant be done but Id love to see what you wizards can do for me. Before I get to the specifics I just want to let you know that I greatly appreicate yoi taking the time to read my post and/or helping me with this matter. I am in your debt.

So I am looking for a code to include into a macro that will take a cell in Column G, Highlight it Orange, Accent 6, Lighter 40% based on a value of a cell in column AX.

**Specifics**
(I made this before i learned about the insert table feature, figured it might have some value so I left it)
Header [ ..G.. ] ........................................[ ..AX.. ]
..G10 [ ..10.. ] <-- Total
..G11 [ ..5.. ] <-- 50% .......................AX11 [ ..50%.. ]
..G12 [ ..2.9.. ] <-- 29% (79%) ...........AX12 [ ..79%.. ]
..G13 [ ..2.1.. ] <-- 21% (100) ............AX13 [ ..100.. ]

G Column	AX Column
10
5	50%
2.9	29%(79%)
2.1	21%(100%)

I hope you can decipher this diagram. What I want it to do is Highlight any cell in G that is less then or equal to 79.99% based on the number in cells in the AX Column. I Will be happy to explain this further if needed.

XOXO

**Aardigspook** · 08-03-2015, 04:12 PM

Hi,

Is there a reason you need this to be in a macro? Because Conditional Formatting will do it very easily. Select the range in G you want to be formatted (let's say G3:G100), go to 'Conditional Formatting' on the Home tab, select 'New Rule' then 'Use a formula to determine which cells to format'. Now enter this formula in the box below:

Formula:

Please Login or Register  to view this content.

then select the formatting you want using the 'Format' button (Fill ... Orange/Accent6/Lighter40%). Click OK and the cells in the column G range will be coloured based on the values in column AX.

If you really need this to be in a macro, you could just start a macro recording, do the above steps, stop the macro, then have a look at the code. That would give you something like this:

Please Login or Register  to view this content.

The code above could be tidied up quite a bit but that gives you an idea of the sort of expressions you'd need.

Regards,
Aardigspook

If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark Thread as Solved'.
You don't need to give me rep if I helped, but thanks are appreciated.