Check boxes and conditional formatting

[fogharty]

I'm still working with a worksheet, and I got it so if you type or
select from a list the word "TRUE" into a cell in column G, then
columns A-F in that row will have their font changed to bright red.

So that's figured out.

But if I want to get all fancy and put a checkbox or radio button in
each cell of the G column that will do the same thing (change the font
color of the row to red, then back to black when unchecked) how do I
do that? I got a macro to work on checking the box, although I don't
know how easily I can copy and paste it all for 1500+ rows) but I
can't assign a "turn to black" macro on the same checkbox.

Clear? Hmmm?

Maybe I should just forget about it all and leave it with my drop-down
list.

I'm working in Mac Excel 2008, and also 2004 (to create the macros.)

 

[Bob Greenblatt]

I'm still working with a worksheet, and I got it so if you type or
select from a list the word "TRUE" into a cell in column G, then
columns A-F in that row will have their font changed to bright red.

So that's figured out.

But if I want to get all fancy and put a checkbox or radio button in
each cell of the G column that will do the same thing (change the font
color of the row to red, then back to black when unchecked) how do I
do that? I got a macro to work on checking the box, although I don't
know how easily I can copy and paste it all for 1500+ rows) but I
can't assign a "turn to black" macro on the same checkbox.

Clear? Hmmm?

Maybe I should just forget about it all and leave it with my drop-down
list.

I'm working in Mac Excel 2008, and also 2004 (to create the macros.)

use a conditional format as you have already done, but have the format
look at the contents of the cell that the control links to.

 

[fogharty]

Thanks, that worked!

So now I have the conditional formatting all working, I just need to
figure out how to copy and past a 1000+ check boxes for each row in
column "G" and have it link to the relative cell for each row; I can
do it manually, but there *should* be a way to automate it, wither
with AppleScript or a macro.

 

[Bob Greenblatt]

Thanks, that worked!

So now I have the conditional formatting all working, I just need to
figure out how to copy and past a 1000+ check boxes for each row in
column "G" and have it link to the relative cell for each row; I can
do it manually, but there *should* be a way to automate it, wither
with AppleScript or a macro.

use a conditional format as you have already done, but have the format
look at the contents of the cell that the control links to.

Ther is indeed a way to automate it with either Applescript or an XLM
macro. You'll have to write a macor to do it.

 

[fogharty]

Thanks Bob.

Ummmm.... you wouldn't happen to know a macro to do that, would you?

 

[Bob Greenblatt]

Thanks Bob.

Ummmm.... you wouldn't happen to know a macro to do that, would you?

Ther is indeed a way to automate it with either Applescript or an XLM
macro. You'll have to write a macor to do it.

There is NO macro to do what you wnat. You, or someone else, will have
to write one.