Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

Conditional formating between sheets?

Posted by Mandy on November 26, 2001 2:02 AM

Have mastered conditional formating on one worksheet,

I would like to change the format of a cell or preferably row from the information contained in another worksheet (within the same workbook)

i.e. if the value of sheet 1 cell D5 is "Y"

then Sheet 2 cell A5 is shaded red (or preferably A5:G5 is red)

Can't seem to figure it out, please help!

Thanks

W98Se
E97

Mandy.B

Re: Conditional formating between sheets?

Posted by Mandy on November 26, 2001 2:04 AM

Forgot to mention the cells I wish shaded, already have data in them, which must stay unharmed
Thanks

Re: Conditional formating between sheets?

Posted by Aladin Akyurek on November 26, 2001 2:21 AM

Activate D5 of Sheet1, go to the Name Box on the Formula Bar, type TargetCell, and enter.

Activate A5:G5 of Sheet2,
activate Format|Conditional Formatting,
choose "Formula Is" for Condition 1,
enter as formula:

=TargetCell="Y"

activate Format,
activate the Patterns tab,
choose the color you want,
click OK,
click OK.

Aladin

=============

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.