| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple Column Cell Compare looping through Rows
Hi I have a problem...... I need to compare 3 cells of data in
different columns D, E, and F. And Change the color of said cell t Red if it is higher than the Cell in Column D and Green if it is Lowe than the cell in column D. I need to do this for every row in th worksheet starting with row 2. I have this all worked out on paper but can't seem to get the synta right. Keep in mind I'm more used to VB.Net than VBA and I'm learnin as I go certain things just don't fly in VBA. Any amount of help woul be greatly appreciated. Thanks N -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maddening Dilemma - Compare each cell within column a to each cell in column b and find unique matches | Excel Worksheet Functions | |||
| Multiple Cells/rows in Column selected when a single cell is click | Excel Discussion (Misc queries) | |||
| count rows in a column for looping | Excel Discussion (Misc queries) | |||
| Compare and display multiple rows | Excel Worksheet Functions | |||
| Formula to compare multiple rows values based on another column? | Excel Worksheet Functions | |||
![nickg420[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
