Ask Your Question
0

How can I apply a conditional format that depends on the comparison with another value?

asked 2018-07-08 16:44:01 +0100

cerr gravatar image

Hi,

Assume I have a table with integer data in column A, I also have integer data in column B and I want to apply green color to the number in B when the value in B is > than the value in A, red otherwise. How can I do this?

I know that I could add a column C,calculate A-B and if the value is >0 apply one format, if <0 apply another. But I'm wondering if there's a better way to directly apply a format without a "helper" column?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2018-07-08 17:57:30 +0100

kompilainenn gravatar image

I should use formula in condition (see attach)C:\fakepath\condition B>A.ods

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-07-08 16:44:01 +0100

Seen: 23 times

Last updated: Jul 08