If this Cell Range contains True in each field, Highlight this different range in the same colour, No

[billsfree]

Hi.

New to Excel and was wondering if someone might be kind enough to lend me a hand

I have an Excel Worksheet with 8 columns:
The first range is D1:D4 (All Text Values)

The range adjacent is D5:D8 (All Boolean values)

Conditional Formatting formula: If(D5 AND D6 AND D7 AND D8) = True, Highlight the 8 fields in light green, otherwise do not do anything...

If((E2:H2) = "True", FORMAT(A2:D2) light green,""))

Sorry.. this is probably a stupid question but I have been working on this and trying to figure it out but just cannot get the range A2:D2 to also be light green if the range D1:D4 all equal true.
Another idea I had is maybe it is easier to refenece the row ? For example, if the 4 columns are true then highlight the row to light green, otherwise leave the row as it is...

Thanks for taking the time to read my Post and I hope you have an awesome Thursday !!!

Oblio

 

[etaf]

not sure i follow

is this what you are after

If((E2:H2) = "True", FORMAT(A2:D2) light green,""))

=AND($E2=TRUE,$F2=TRUE,$G2=TRUE,$H2=TRUE)

Book3
	A	B	C	D	E	F	G	H
1
2					TRUE	TRUE	TRUE	TRUE
3							TRUE
4
5						TRUE
6					TRUE	TRUE	TRUE	TRUE
7					TRUE	TRUE	TRUE	TRUE
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:D7	Expression	=AND($E2=TRUE,$F2=TRUE,$G2=TRUE,$H2=TRUE)	text	YES

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
A2:D100 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=AND($E2=TRUE,$F2=TRUE,$G2=TRUE,$H2=TRUE)

Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

 

[billsfree]

not sure i follow

is this what you are after



=AND($E2=TRUE,$F2=TRUE,$G2=TRUE,$H2=TRUE)

Book3
	A	B	C	D	E	F	G	H
1
2					TRUE	TRUE	TRUE	TRUE
3							TRUE
4
5						TRUE
6					TRUE	TRUE	TRUE	TRUE
7					TRUE	TRUE	TRUE	TRUE
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:D7	Expression	=AND($E2=TRUE,$F2=TRUE,$G2=TRUE,$H2=TRUE)	text	YES

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
A2:D100 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=AND($E2=TRUE,$F2=TRUE,$G2=TRUE,$H2=TRUE)

Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

MARRY MEEEEEEEEEEEE !!! OMG I honestly thought there is NO WAY to do this !!! I CANNOT BELIEVE your answer... so perfectly illustrated and detailed. Can I but you something... it really would be my pleasure to do so...

And Thanks SOO Very MUCH for taking the time to answer my question and SO Quickly

 

[etaf]

you are welcome

you could also use
=COUNTIF($E2:$H2,TRUE)=4

i suspect a few other formulas too

 

[billsfree]

MARRY MEEEEEEEEEEEE !!! OMG I honestly thought there is NO WAY to do this !!! I CANNOT BELIEVE your answer... so perfectly illustrated and detailed. Can I but you something... it really would be my pleasure to do so...

And Thanks SOO Very MUCH for taking the time to answer my question and SO Quickly

YES ! It works perfectly !!!

 

[etaf]

excellent

 

[billsfree]

you are welcome

you could also use
=COUNTIF($E2:$H2,TRUE)=4

i suspect a few other formulas too

I assume =4 is based on the value of True ? I kept trying to figure out how to bring the colour in as well... honestly, thanks and can I buy you a gift card or e-transfer ?

 

[etaf]

the number of TRUE in the count if
so as
$E2=TRUE,
AND $F2=TRUE,
AND $G2=TRUE,
AND $H2=TRUE)

so all 4 therefore hence the count of how many TRUE's there in in the range E:H , must be 4 for the condition to be TRUE and colour

I kept trying to figure out how to bring the colour in as well.

Not sure what you mean
conditional formatting the cell - when the formula is TRUE - so
countif()=4 will only be TRUE when the range has 4 true's and then colour

honestly, thanks and can I buy you a gift card or e-transfer ?

Thats very kind of you , but this forum is available for free help , and people volunteer to give there time , as i do , for no reward , other than helping people with solutions
also in my retirement keeps the brain cells active

 

[billsfree]

the number of TRUE in the count if
so as
$E2=TRUE,
AND $F2=TRUE,
AND $G2=TRUE,
AND $H2=TRUE)

so all 4 therefore hence the count of how many TRUE's there in in the range E:H , must be 4 for the condition to be TRUE and colour

Not sure what you mean
conditional formatting the cell - when the formula is TRUE - so
countif()=4 will only be TRUE when the range has 4 true's and then colour


Thats very kind of you , but this forum is available for free help , and people volunteer to give there time , as i do , for no reward , other than helping people with solutions
also in my retirement keeps the brain cells active

I really cannot thank you enough !!! Just trying to modify it to Yes or No so I will need to go over it again to make sure I understand it... Again SO many thanks !!!

 

[etaf]

ok,
changing what to yes/no - if we can help let us know