Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Formatting
Hi
This must be simple but just can't get my head around it. I have VB code that runs through a number of cells and checks against the value of another set of cells. What I would like to do is change the background color of a cell to yellow if the call matches. I thought I had tried everything but does not seem to like anything I do. This is part of the code: While Not Cells(RwIndex, CoIndex).Value = "" ChkValue = Cells(RwIndex, CoIndex).Value Select Case ChkValue Case Cells(2, 4) Cells(RwIndex, CoIndex).????????? I would appreciate your help. Many Thanks Steve |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Formatting
Steve,
You can change the background color of the cell to yellow with code like Cells(RwIndex, CoIndex).Interior.ColorIndex = 3 -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Steve" wrote in message ... Hi This must be simple but just can't get my head around it. I have VB code that runs through a number of cells and checks against the value of another set of cells. What I would like to do is change the background color of a cell to yellow if the call matches. I thought I had tried everything but does not seem to like anything I do. This is part of the code: While Not Cells(RwIndex, CoIndex).Value = "" ChkValue = Cells(RwIndex, CoIndex).Value Select Case ChkValue Case Cells(2, 4) Cells(RwIndex, CoIndex).????????? I would appreciate your help. Many Thanks Steve |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Formatting
Thanks Chip
I'm sure I tried that. Still, Appreciate you help. If I wanted my spreadsheet to continuously check and then Highlight, can this be done? At the moment I have this code attached to a button so it is a manual process. Best Regards Steve -----Original Message----- Steve, You can change the background color of the cell to yellow with code like Cells(RwIndex, CoIndex).Interior.ColorIndex = 3 -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Steve" wrote in message ... Hi This must be simple but just can't get my head around it. I have VB code that runs through a number of cells and checks against the value of another set of cells. What I would like to do is change the background color of a cell to yellow if the call matches. I thought I had tried everything but does not seem to like anything I do. This is part of the code: While Not Cells(RwIndex, CoIndex).Value = "" ChkValue = Cells(RwIndex, CoIndex).Value Select Case ChkValue Case Cells(2, 4) Cells(RwIndex, CoIndex).????????? I would appreciate your help. Many Thanks Steve . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions |