Change font and background color of several cells based on result of a formula

[Zenaida]

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.

[Bob Phillips]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Zenaida]

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