| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
searching
hi folks
in column J i have either True or False i want to search column J and if i find True i want to change the coresponding cell in column A to Green any ideas thanks in advance |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
searching
Use Conditional Format. Say your data starts in Row 1. With A1 selected,
click on Format - Conditional Formatting. In the first block, select "Formula is:". In the block to the right, enter =J1=TRUE. Select the color you want for the formatting. Drag cell A1 down as far as you expect Column J data to go. Done. HTH Otto "Arnie" wrote in message ... hi folks in column J i have either True or False i want to search column J and if i find True i want to change the coresponding cell in column A to Green any ideas thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Searching for... | Excel Discussion (Misc queries) | |||
| Set Up Searching | Setting up and Configuration of Excel | |||
| Searching, matching then searching another list based on the match | Excel Discussion (Misc queries) | |||
| VBA searching | Excel Programming | |||
| Searching | Excel Programming | |||
Hybrid Mode
