Wednesday, July 30, 2014

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   Jul-30-2014
post by Emmett Armstrong:
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: 

Thank you for all you do to support this community 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:
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