no one is over at the other groups so posting here

[ric s]

can this be simplified. I just want each cell in the T row to follow the custom color formula. ex: if the number in the cell is greater than 90 change cell color to red. =AND(A:A=26,O:O>90) and =AND(A:A=26,O:O>60) orange, etc. the apply range to me is all over the place just to get to the (custom formula is) here is the apply range. O1:O3,P1:P5,R1:S3,T1:T5,W1,X1:X6,Y1:AG4,V2:V4,W3:W4,R5:S5,V6,T8:AG137

[cwl...@gmail.com]

I think you can get away with  =AND(A2=26, O2>90)  and then apply the formula across the desired range (T2:T).  This assumes a header row and data starts at row 2. 

[ric s]

Hello, and thank you for your help. 

I put in the field (row) that the numbers would calculate, but the colors did not change. 

I don't know if it is being applied to the sheet or if the sheet is damage.?  

[ric s]

Cw I can add you to the sheet and maybe you see if something is wrong with it. ?

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/7d613c01-f6d4-413a-aee4-7e62e7f43765n%40googlegroups.com.

[cwl...@gmail.com]

sure.

[ric s]

Thanks. 

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/1041b618-3abd-4818-84bd-490e4fc426f1n%40googlegroups.com.

[cwl...@gmail.com]

Sorry, I think I blocked you and the share. I get a lot of stuff shared with me that is Phishing or Spam, and I forgot you were going to share your sheet. Can you share it again, or post the link?