Conditional formatting- Formula to high light cells using IF based on another formula being FALSE

[LUV4XL]

Hi,
[TABLE="width: 1277"]
<colgroup><col></colgroup><tbody>[TR]
[TD]I'm trying to build a simple dashboard based on staffing schedule.[/TD]
[/TR]
[TR]
[TD]Daily data entered in the first sheet with name, time in and time out with drop down split by qtr hr.[/TD]
[/TR]
[TR]
[TD]we have 2 teachers for the classroom.[/TD]
[/TR]
[TR]
[TD]Second sheet highlights green in the Qtr hr based on input from sheet 1(used formula in conditional formatting) - FIRST FORMULA[/TD]
[/TR]
[TR]
[TD]Now, if a particular Qtr hr say 7.15 doesn't have any teacher highlighted GREEN, I want the cells highlighted RED. If either one is GREEN, Then no changes required. - SECOND FORMULA[/TD]
[/TR]
[TR]
[TD]How to write an IF Formula based on the FIRST formula for conditional formatting.[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]SECOND FORMULA = HIGHLIGHT RED IF ( FIRST FORMULA IS TWO CELLS ARE FALSE)[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]Please help![/TD]
[/TR]
[TR]
[TD]Appreciate your time and support![/TD]
[/TR]
[TR]
[TD]Thanks,[/TD]
[/TR]
[TR]
[TD]K[/TD]
[/TR]
</tbody>[/TABLE]

 

[LUV4XL]

I figured this out! Never Mind!