ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   IF three functions are....... (https://www.excelbanter.com/excel-worksheet-functions/157372-if-three-functions.html)

mndpy

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!


David Biddulph[_2_]

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!




mndpy

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