How to highlight a cell only if value exist and leave if blank

[mattbarb]

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; color: #000000}</style>Highlight a cell if cell two rows on the left has x value. If blank do no highlight.


Err how would i do this?

Thanks,

Matt

 

[tyija1995]

Hey,

Use a custom rule (Say you want the highlighter cell to be cell C1)

Select C1
Conditional formatting -> New Rule -> Use a formula to determine which cells to format -> =A1="Value goes here" Then select the format you want.

This will format C1 if cell A1 contains "Value goes here" - just change the text to whatever x is.

 

[mattbarb]

SorryIm looking for the formula, somthing like:

=NOT(ISBLANK($I17))

But i need it to just find value two rows to left.

 

[tyija1995]

OK

In that case use OFFSET:

=NOT(ISBLANK(OFFSET($I17,0,-2)))

This offsets $I17 by 2 columns (to the left hence the minus) and therefore looks at $G17

 

[mattbarb]

 

[mattbarb]

Thanks for your help by the way