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