I'm using "Use a formula to determine which cells to format" and in the formula bar I simply click the cell in the sheet I want cells formatted with equal value, and it fills in the bar correctly with "=$H$6" which has a value of 15 saved like this the entire column is formatted, regardless the values. Am I misunderstanding this formatting rule?
Bookmarks