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

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

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