Archive of Mr Excel Message Board

Back to Dates in Excel archive index
Back to archive home

Applying conditional format to a column with a formula (using RC notation?)

Posted by Mark Folse on July 24, 2001 1:54 PM

I can't figure out how to format the formula to use RC notation, so that an existing column of text entries can be formated based on the contents of an existing cell set of one to the right.

I've done this in the past doing it before data entry (format and drag/paste a template cell). but now its too late.

Re: Applying conditional format to a column with a formula (using RC notation?)

Posted by Mark W. on July 24, 2001 2:12 PM

=RC[1]

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.