Conditional formatting based on a field below

Question

Hi, I have the following table:&nbsp;Each actual value is relating to the "Planned" value below. I would like each "Actual" value to have a red colour if the planned value is 0 or green if the number is equal to the "Planned" value below. Each field can have a different planned value, so I need a smart formula.Are they any ways to do it? Thank you

peteryac60 · Answer

Wojciech_Plonka&nbsp;Hi&nbsp;I think this might be what you want? This uses conditional formatting and might help you?&nbsp;BTW - is there any reason why you have to layout with actual above planned? If you have actual next to planned (as shown on the right hand side) that it is easier to understand and the formatting also is simpler.&nbsp;hope this helps.&nbsp;Peter

philiptx · Answer

Wojciech_Plonka&nbsp;I tried to replicate what you ask for. Something like that?

mathetes · Answer

Wojciech_Plonka&nbsp;&nbsp;Absolutely there are ways to do it.&nbsp;If I were you, however, I'd put the cells side-by-side if you can. Makes it easier, and probably would make more sense design wise.&nbsp;Anyway, here's an example. I used a random number generator just to put it through its paces. To get a whole new set of numbers, just activate the F9 key. With a mac that's done by holding the Fn key and pressing the key along the top row with F9 appearing on it.&nbsp;

mathetes · Answer

You and I think alike. I made the same recommendation: change to side-by-side!

wojciech_plonka · Answer

Well, the trick is - there will be thousands of rows like this, so setting this up manually would be a hell, also, changing format is impossible unfortunately

PhilipTx mathetes peteryac60

Forum Discussion

Conditional formatting based on a field below

6 Replies