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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
searching
Arnie
Here is the code in a self-standing macro. You will have to extract the meaningful parts and insert them into your macro. HTH Otto Sub ChangeColor() Dim RngJ As Range Dim i As Range Set RngJ = Range("J1", Range("J" & Rows.Count).End(xlUp)) For Each i In RngJ If i.Value = True Then _ Cells(i.Row, 1).Interior.ColorIndex = 4 Next i End Sub "Arnie" wrote in message ... i'm going to need the code for this as when i spit this spreadsheet out from Access and run my macro(in Excel) to do what i want it to do the conditional formating is lost. if i re-select the range A1:A300 and click on conditional formating the condition is there but has now changed to =L1=TRUE etc. So i need to run this formating at the end of my auto open macro "Otto Moehrbach" wrote: 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 |