EXCEL

excel conditional formatting outside of range

# Basic syntax:
=IF(OFFSET(A1:H100, 0, 1)="Text", TRUE, FALSE)
# Where:
#	- This formula would be used in the Formula section of conditional
#		formatting and will highlight all cells whose adjacent cell contains
#		the word "Text"
# Note, with OFFSET, the IF condition can be true even if the condition refers
#	to cells outside of the conditional formatting range. For example, if cell
#	I1 contained "Text", then H1 would be highlighted
# Note, when applying conditional formatting to a multi-cell range at once,
# 	you need to write the formula as it pertains to the very first cell in
#	that range