software

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 gt; 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: www.excelforum.com/member.php...oamp;userid=33802
View this thread: www.excelforum.com/showthread...hreadid=536883CF would easily work, select all sheets, select V26:W29 and use a formula of

=$W$27gt;$T$29

and format the colour to that colorindex.
--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Zenaidaquot; gt; wrote in
message ...
gt;
gt; I have a workbook that has 6 spreadsheets in it. The layout of all 6
gt; spreadsheets is identical. The information they contain is different.
gt;
gt; I cell W27 gt; T29 then I want the background color and font color for
gt; cells V26:W29 to be ColorIndex 40. If the result is false, I don't
gt; want any changes.
gt;
gt; I know how to do conditional formatting but I don't see how it would
gt; work with what I want to do.
gt;
gt; Is there code I could use in the worksheet event?
gt;
gt; Thanks for your time.
gt;
gt;
gt; --
gt; Zenaida
gt;
gt;
gt; ------------------------------------------------------------------------
gt; Zenaida's Profile:
www.excelforum.com/member.php...oamp;userid=33802
gt; View this thread: www.excelforum.com/showthread...hreadid=536883
gt;

Thanks for helping me get my brain out of quot;stuckquot; mode. I used your
formula with CF and it works perfect! Thanks again.--
Zenaida------------------------------------------------------------------------
Zenaida's Profile: www.excelforum.com/member.php...oamp;userid=33802
View this thread: www.excelforum.com/showthread...hreadid=536883