View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Check Boxes and Conditional Formatting

You could use a font of Marlett, and input a value of 'a' for a check, and
then add a conditional formatting formula;a of =$A1 to each cell in the
row.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Steve" wrote in message
...
Can I set up a check box so that when it is checked, a specific row bg

color
turns to a specific color?

Thank you for your help,
Steve