Forum Discussion
Conditional Formatting based on column value
Hi Guys, I have a column showing current stock and a column showing required stock holding. If the required stock holding is >= current stock, I want that to be coloured in Green If the requ...
Here you can see that the Sales column has been conditionally formatted based on the values in the Profit Column. Hope this helps
Hi Thanks for that, but does not seem to help im my situation, any numbers I add I dont get any different results.
I assume I use the maximum number? I tried 500 up to your example, 20000:
Yes, you can change Percentage to Number in the Rules dropdown. Also type >= Max in the second rule on the right hand side condition