Conditional Formatting if specific cell greater than 100

[mattbarb]

Hi,

This simple formula is driving me nuts. Im trying to create a formula that detects if a a cell is greater than 100 and changes the colour of that cell. I thought this would work:

=$K$11>100

Thanks

Matt

 

[tyija1995]

Hi,

Which cells do you want to apply this rule to?

From what I gather, you want to colour certain cells based on whether cell K11 is greater than 100?

 

[mattbarb]

Yes thats right one specific cell, say A1.

 

[tyija1995]

OK - with just A1 selected go into conditional formatting, New Rule -> Use a formula to determine which cells to format -> =$K$11>100 -> Format as you wish, this will format A1 if K11 is greater than 100