yogi_Conditionally Format Cells If The Integer Value Of Cell Is A Specified Value

                           Google Spreadsheet   Post  #1714
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul-30-2014
post by Emmett Armstrong:
(https://productforums.google.com/forum/#!mydiscussions/docs/OsjqOTXZQl4)
New Conditional Formatting option - Custom formula is
Hi Yogi,

This isn't exactly the problem I'm having. I've created a sheet with example data to show my problem more clearly: 

https://docs.google.com/a/revthink.com/spreadsheets/d/1B8ObKoXMPbZvkTSrZXEj2rYkSmfBj6qbkE5GfY2MxVY/edit#gid=0

Thank you for all you do to support this community Yogi!

Emmett

---

Yogi,

My problem is with conditional formatting, not a specific formula. I'm sorry I'm not explaining this very well. 

Cell G7 of Sheet 1 on this sheet contains an example as well as a description of my problem:

Conditional Formatting Example

------------------------------------------------------------------------------------------------------------------------------

formatting of a cell can not be used as a creiterion for Conditional Formatting in a formula based approach -- do have a look at my use of INT() function to meet the intent of your inquiry