Conditional formatting, change row to certain color

[Sylvan06]

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?

 

[Sylvan06]

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!

 

[Chin via OfficeKB.com]

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.