Hi all
On the attached example, I'm looking for a way in which I can have cell D2 automatically highlighted as a different colour based on if it matches criteria. This is what I need:
Cell D2 will be coloured green if it is equal or less than cell C2.
Cell D2 will be coloured orange if it is higher than cell C2 but less than or equal to cell B2.
Cell D2 will be coloured red if it is higher than cell B2.
Can anyone offer any advice please?
Read the link that i provide to learn how to use CF.
How can you use Conditional Formating.
--In Excel 2007 and 2010, Conditional Formatting is in the Styles group on the Home tab. In Excel 2003, Conditional Formatting is on the Format menu. See here how you can work using CF.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
See attached...
Formatting Example(1).xlsx
I simply created 3 formula rules...
For Green... =D2<=C2
For Yellow.. =AND(D2,D2<=B2)
For Red..... =D2>B2
Make sure to check of the "Stop If True" for the Green & Yellow...
Let me know if this is what you are looking for...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks