| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change cell color if data present excel 2002
I have a worksheet with two columns and multiple rows of data in a
workbook that contains multiple sheets. Column "A" has location information and column "B" has the owner information. I would like to know how to automate the sheet to look at column "A" and if there is data present then look at the corresponding cell in column "B" (i.e "A3" then look at "B3") and if there isn't any data in "B" then change the color. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell color does not show on screen excel 2002 | Excel Discussion (Misc queries) | |||
| Any way to change the color of the cell corner identifier that shows a comment is present? | Excel Discussion (Misc queries) | |||
| Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
| How do I change cell color based upon data range within the cell? | Excel Worksheet Functions | |||
| How do I change fill color in excel based on data in the cell | Excel Worksheet Functions | |||
![Mike[_80_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
