Excel Tricks

Conditional formatting: TFS reports

Conditional formatting: Refer to a cell of the cell to the left or top

=OFFSET(INDIRECT(ADDRESS(ROW(), COLUMN())),0,-1)

https://superuser.com/questions/418036/how-to-apply-conditional-formatting-based-on-previous-cell-value

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s