Conditional formatting - multiple conditions

[radekrat]

Hello all

Can anyone tell me how to set up formula for conditional formatting to highlight rows where a value in any of the cells is negative (<0)?

if not possible for all cells, I am expecting negative values in columns $N7, $U7, $AB7 , $AI7, $AP7, $AV7, $BD7 , $BK7, $BR7

Range I7 - BS54


Been trying for an hour with mixed results.


Any help is greatly appreciated

[ChemistB]

Select I7:BS54
Conditional Formatting> New Rule> Use Formula

Please Login or Register  to view this content.

Format as desired

[JohnTopley]

Try

* Use formula ......... (Conditional Formatting)

=$N7<0

Applies to

$n$7:$n$54

Set fill to required colour

REpeat for each column

[radekrat]

Thanks all,
I have also found out that OR($N7<0,$U7<0,$AB7<0) worked? Or was I just lucky and it wouldn't be valid in every case?

[JohnTopley]

How have you defined "Applies to" ?

Using

=$N$7:$N$54,$U$7:$U$54,$AB$7:$AB$54

it highlights all columns (N,U,AB) whenever any of N,U,AB have a negative value:

I initially used the OR condition but was not sure if the outcome above was acceptable.

[radekrat]

Can I ask for ideas on how to create formula for another conditional formatting please:

currently in the attached test spreadsheet I have formula o highlight rows where sum of values in columns N, U, AB = 0 ======> =SUM($N7,$U7,$AB7)=0

But what would work better for me and can't quite get it working would be if I can highlight rows where:


sum of values in columns N, U, AB = 0
sum of values in columns I, P, W >0


This would show me exact spot where I run out of volume


Many thanks for your help - This community is the best!!

[JohnTopley]

Try

=AND(SUM($N7,$U7,$AB7)=0,SUM($I7,$P7,$W7)>0)

Applies to

$i$7:$AB$54

[radekrat]

Try

=AND(SUM($N7,$U7,$AB7)=0,SUM($I7,$P7,$W7)>0)

Applies to

$i$7:$AB$54

works Thank you