View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Zenaida
 
Posts: n/a
Default Change font and background color of several cells based on result of a formula


I have a workbook that has 6 spreadsheets in it. The layout of all 6
spreadsheets is identical. The information they contain is different.

I cell W27 T29 then I want the background color and font color for
cells V26:W29 to be ColorIndex 40. If the result is false, I don't
want any changes.

I know how to do conditional formatting but I don't see how it would
work with what I want to do.

Is there code I could use in the worksheet event?

Thanks for your time. :)


--
Zenaida


------------------------------------------------------------------------
Zenaida's Profile: http://www.excelforum.com/member.php...o&userid=33802
View this thread: http://www.excelforum.com/showthread...hreadid=536883