Conditional formatting, change row to certain color
 

I have a check box in K6......how can I set it up so that when the check box
is checked, it changes the font color in L6 through T6 to red?

Conditional formatting, change row to certain color
 

The problem is that the check box in not really IN cell K6 is it positioned
OVER the cell K6
You need to link the check box with K6; right click the check box; open the
Format Control dialog and go to the Control tab. Now link the control to K6
using the Cell Link box.

Now K6 will have the value TRUE when the box is checked and FALSE otherwise
(we will hide this later)
Select L6:T6 and use Format | Conditional Formatting; enter the very simple
formula =$K6 and set the format you need (font colour red)

When everything is working we need to hide the TRUE/FALSE is one of two ways
(a) move to K5, press down arrow to get to K6 and use Format | Format Cell
and set the font color the same as the background colour (white?)
or
(b) right click the control; open the Format Control dialog, open the Colors
and Line tab and give the control a fill color (white will do). You many
need to adjust the sixe of the control to prevent the fill spilling into
other cells.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Sylvan06" wrote in message
...
I have a check box in K6......how can I set it up so that when the check
box
is checked, it changes the font color in L6 through T6 to red?

Conditional formatting, change row to certain color
 

Thanks Bernard! Exactly what i was looking for. I was close with what I had
(on the tip of my tongue so to speak) and just needed a boost. Appreciate it!

"Bernard Liengme" wrote:

The problem is that the check box in not really IN cell K6 is it positioned
OVER the cell K6
You need to link the check box with K6; right click the check box; open the
Format Control dialog and go to the Control tab. Now link the control to K6
using the Cell Link box.

Now K6 will have the value TRUE when the box is checked and FALSE otherwise
(we will hide this later)
Select L6:T6 and use Format | Conditional Formatting; enter the very simple
formula =$K6 and set the format you need (font colour red)

When everything is working we need to hide the TRUE/FALSE is one of two ways
(a) move to K5, press down arrow to get to K6 and use Format | Format Cell
and set the font color the same as the background colour (white?)
or
(b) right click the control; open the Format Control dialog, open the Colors
and Line tab and give the control a fill color (white will do). You many
need to adjust the sixe of the control to prevent the fill spilling into
other cells.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Sylvan06" wrote in message
...
I have a check box in K6......how can I set it up so that when the check
box
is checked, it changes the font color in L6 through T6 to red?

Conditional formatting, change row to certain color
 

Sylvan, if you are using Excel 2007:

1. Highlight the entire table/range.
2. At "Home" menu, choose "Conditional Formatting".
3. Click on "Manage Rules"
4. Click on "New Rules"
5. Choose "Use a formula to determine which cells to format".
6. In your example, the formula should be similar to: =$K6="X" (assuming you
use "X" as "check")
7. Click on "Format" and change font color to red
8. Click "Ok", "Ok", "Apply", "OK".

Please advise if this helps.


Sylvan06 wrote:
I have a check box in K6......how can I set it up so that when the check box
is checked, it changes the font color in L6 through T6 to red?

--
Message posted via http://www.officekb.com