IF three functions are.......
I need a formula to use with conditional formatting that does all the
following: If G4=Y (TEXT) If G13=R (TEXT) IF O1328 (Number) Then changes it to what color I choose. I want it to tell me when a 14/15 old is working more than 28 hours a week when school is in session. So any help would be apprecited. Thanks! |
IF three functions are.......
=AND(G4="Y",G13="R",O1328)
-- David Biddulph "mndpy" wrote in message ... I need a formula to use with conditional formatting that does all the following: If G4=Y (TEXT) If G13=R (TEXT) IF O1328 (Number) Then changes it to what color I choose. I want it to tell me when a 14/15 old is working more than 28 hours a week when school is in session. So any help would be apprecited. Thanks! |
IF three functions are.......
Thanks! That worked great!
"David Biddulph" wrote: =AND(G4="Y",G13="R",O1328) -- David Biddulph "mndpy" wrote in message ... I need a formula to use with conditional formatting that does all the following: If G4=Y (TEXT) If G13=R (TEXT) IF O1328 (Number) Then changes it to what color I choose. I want it to tell me when a 14/15 old is working more than 28 hours a week when school is in session. So any help would be apprecited. Thanks! |
All times are GMT +1. The time now is 07:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com