Conditional formatting with multiple conditions

[Bebbspoke]

Hi Peoples; -
I'm sure there is a simple way around this - please help me find it!

A block of data cells (B4:BC27) contain either "FALSE" or "TRUE", and the individual column headers (B3:BC3) may be labelled "Buy" or "Sell"...

Req. is to highlight all "Buy & TRUE" in one colour and all "Sell & TRUE" to a different colour...

Your suggestions, thank you.
John

 

[wideboydixon]

Select B4:BC27 and add a conditional format based on the following:

=AND(B4=TRUE,B$3="Buy")

Similarly one for:

=AND(B4=TRUE,B$3="Sell")

WBD

 

[Bebbspoke]

Many thanks WBD - problem solved!

 

[Bebbspoke]

Hi folks new "conditional formatting" problem; -

col n may contain "r" or "g" as (formulated) text... col AA may contain the digit 1

Requirement is to colour code col AA where and(n3="r",AA3=1) similar (in different colour) where and(n3="g",AA3=1), both thru to nxxx & AAxxx

suggestions please, thanks