Forum Discussion
Conditional Formatting
Using excel 16.69- It appears using the new excel is not as easy as past editions. That being said. I want to use conditional formating to do the following condition on a budget. I want to change cel...
This is the pop up I see, I don't see how I can do the percentages for yellow. I can do green using a calculated number. For example 425 for 85% to turn green and 501 to turn red.
any help is appreciated.
- green when less than or equal to 84.999%
- yellow when between 85 and 99.999%
- red when >100%
Still not knowing exactly how you've arrayed your full sheet, here's a suggestion as to how to accomplish the conditional formatting. I use the Classic ... Formula approach,
and I've attached the sample worksheet to this message.
Here is a link for further study on conditional formatting, which can be tricky. I often have to try several times to get it to work as desired. So don't be too hard on yourself.