Hi I want to insert conditional formatting to a range of cells so that if the number in the cell is greater than 30 it is coloured red. If it is lower than 3 then it is green. If it is between the range of 3 and 30 then it is amber. Has anyone any idea how this is done? I also want this to run a macro after I fully understand how to do it (I know this isnt the macro part but I just wanted to out it out there)
the ranges are ("H5:H19, H21:H24, H26:H29, H26:H29, H31:H36, H38:H44")
for 2007 or 2010 excel version
Conditional Formatting
Highlight applicable range >>
"H5:H19, H21:H24, H26:H29, H26:H29, H31:H36, H38:H44"
Home Tab >> Styles >> Conditional Formatting
you would need to add three rules
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
= H5 > 30
Format… [Number, Font, Border, Fill] - RED
OK >> OK
New Rule
= H5 < 3
Format… [Number, Font, Border, Fill] - GREEN
OK >> OK
new rule
= AND( H5 >= 3, H5 <=30 )
Format… [Number, Font, Border, Fill] - AMBER
OK >> OK
and then the applies to should be
("H5:H19, H21:H24, H26:H29, H26:H29, H31:H36, H38:H44")
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Why a macro? It's embedded in XL's CF ?
Originally Posted by Pepe Le Mokko
It won't be consistent numbers in the cells do I'm trying to give myself a better understanding of the Conditional Formatting beforehand. I have been working with my macro code for hours but just cannot seem to get it to work.
I know this isn't the macro section but I have solved my problem with a macro anyway, here it is
Formula:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks