I want to set conditional format for Column U.. if the percentage is greater that 10% the cell is light green. If the percentage is less that -10% the
cell turns very light red. See the template attached for how i want it to appear.
Thank you so much in advance for your time and assistances.
Last edited by tlmayo1965; 03-14-2024 at 03:44 PM.
Green formula:Formula:
Please Login or Register to view this content.
Red formula:Formula:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Pretty simple. You already have some conditional formatting rules so I'm not sure why this one is giving you trouble:
Values as displayed
Feb 2024
Conditional Formatting Rules
Cell Value Applies To Formula 1 Formula 2 Operator Format Stop If True $U$2:$U$20 =-0.1 <no formula 2> Less Than False $U$2:$U$20 =0.1 <no formula 2> Greater Than False Feb 2024
thank you so so much for your help.. i greatly appreciate it.. Please know that!!!!
Thank you for your help and assistances.. I am grateful and very appreciative of your time and assistances.
If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."
If a member helped you solve your problem, consider adding to their reputation by clicking addreputationiconsmall.jpg below their name.
You're welcome. Thanks for the rep.
Select the U column.
Go to the Home tab and select Conditional Formatting in the Styles section.
Select New Rules
In the window that appears, select "Format cells containing..."
Enter the condition: "greater than" and the value "10%".
Click on the "Format" button, select the "Fill" tab and select the desired light green color.
Click OK.
To make a cell appear very light red when the percentage value is less than -10%, repeat the same steps, but enter the condition "less than" and the value "-10%", and then select the light red color you want.
You have responded to a thread that is already marked SOLVED and have just repeated the same solutions that have already been posted. Please be judicious and post only when you have something to add.Originally Posted by CarissaKirby
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks