Complicated (for me) conditional Formatting of fields

[DebbieBarry]

Hi All,

So i need some help, i am stuck on this, Basically i have a spreadsheet where i have formatted the columns to go light green if i type a "y" in the field.

What i need help with is how to change another field so that if the other field says y then i also want that field to turn light green.

Ultimately, i then need to do a sum to add up the figures in the field that are light green

Where it shows Price(H column), would like this to turn green if column N has y in it.

I then need to add up the total of all prices then showing in the light green

Hope this makes sence.

thank you for your help

 

[Youngdand]

HI,

You Should keep the 2 separate.

You can use a simple sumif function to sum values where column n is y, and leave the conditional for matting as is, or add further rules to highlight other cells using the same criteria if required.

Eg, =SUMIF(N2:N5,"y",H2:H5)

 

[DebbieBarry]

HI,

You Should keep the 2 separate.

You can use a simple sumif function to sum values where column n is y, and leave the conditional for matting as is, or add further rules to highlight other cells using the same criteria if required.

Eg, =SUMIF(N2:N5,"y",H2:H5)

That's amazing, thank you so much, i couldn't for the life of me think how to do it

x