formula true only if one of the referenced cell is >0

**CLSSY56** · 10-05-2018, 06:26 PM

I have this formula for conditional formatting to change the color of a row of cells.

Formula:

Please Login or Register  to view this content.

How can I change this so it only shows true if F8 is > than 0?

**jeffreybrown** · 10-05-2018, 06:34 PM

**Joske920** · 10-05-2018, 07:15 PM

Hi CLSSY56,

If "somesheet"!F8 > 0 then check if "somesheet"!F7 > "somesheet"!F8 then yes else ""

I think this is it

Please Login or Register  to view this content.

Grtz

**Pete_UK** · 10-05-2018, 07:29 PM

You might want to remove the quotes from around "TRUE" if you want a Boolean value TRUE.

Hope this helps.

Pete

**CLSSY56** · 10-05-2018, 08:36 PM

Originally Posted by jeffreybrown

Yes different part of the same spreadsheet I'm working on.

**CLSSY56** · 10-05-2018, 08:41 PM

Thanks all, I'll have to give it a shot on Monday.

**CLSSY56** · 10-08-2018, 08:34 AM

Formula:

Please Login or Register  to view this content.

I'm not sure if it's working or not... seems to show TRUE, but if it's FALSE it's blank.

**jeffreybrown** · 10-08-2018, 09:12 AM

Can you post a sample workbook with your setup and the formula and then we can see what is happening!

**CLSSY56** · 10-08-2018, 09:42 AM

See attached, the Mazda is the only one with the new formula.

**jeffreybrown** · 10-08-2018, 10:00 AM

For the three rows, mazda, jeep, and ford, what do you expect? Since I have not been following this closely, can you explain what you expect and why?

**CLSSY56** · 10-08-2018, 10:13 AM

Well I was expecting Mazda to say both FALSE and TRUE, but it seems to be working correctly.

Re: formula true only if one of the referenced cell is >0