Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 27th 06, 05:37 PM 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


  #2   Report Post  
Old April 27th 06, 06:23 PM posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default Change font and background color of several cells based on result of a formula

CF would easily work, select all sheets, select V26:W29 and use a formula of

=$W$27$T$29

and format the colour to that colorindex.



--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Zenaida" wrote in
message ...

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



  #3   Report Post  
Old April 27th 06, 06:46 PM 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


Thanks for helping me get my brain out of "stuck" mode. I used your
formula with CF and it works perfect! Thanks again.


--
Zenaida


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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Deferring conditional formatting? Pheasant Plucker® Excel Discussion (Misc queries) 14 March 17th 06 08:17 PM
Event Macro adjustment needed - need to change font color also nick s Excel Worksheet Functions 2 November 28th 05 05:50 PM
How to change the default Border, Font Color, and Cell Color Elijah Excel Discussion (Misc queries) 3 November 2nd 05 11:52 PM
Excel 2003 Font Color and Background Color DrankPA6 Excel Discussion (Misc queries) 1 August 12th 05 11:43 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 04:12 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright ©2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017