MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.


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

=RC[1]