Color coding cells which meet the criteria

[smithy_o7]

I have a huge set of data. In a macro i want all cells which meet a value in an adjacent cell to be automatically colored grey at the click of a macro.

The reason why I am doing it through a macro is because if i use conditional formatting it greys out even the cells which dont contain a value, and there are many of these.

Any ideas on any syntax for doing something like this?

Cheers

[royUK]

What Condition have you set for the Formatting?

[pierre08]

Hi,
Try this:

Please Login or Register  to view this content.

You'll just have to select your set of data or you can just do a loop for that

Hope it help

[smithy_o7]

Will this work even though i have 500 rows of data and each row needs has its own seperate value to be compared against.

Im not sure i understand the macro as im quite new to excel could you please break it down a little more with explanations?

Your help is much appreciated

[royUK]

You have 500 different variations?

[pierre08]

Please Login or Register  to view this content.

If you want join your workbook it'll be much easier to understand what you need

[smithy_o7]

What i have is rows of data indicating a a number (for example 5). In a total cell just for this particular row i may for example have the number 10. Because 5 is less than 10 i want it to turn that cell grey, but because i have cells not containing values i do not want it to highlight the cell grey due to it being less than 10?

Therefore i may have lots of values so i cant just add 1 value and ask the macro to only lookup the one?

[pierre08]

You'll just have to enter your value, and then all the cells that contains a value smaller than the one entered it'll turn grey and it'll not highlight the empty cell grey

Please Login or Register  to view this content.