LinkBack URL
About LinkBacks
I am looking to compare the Month row to the Benchmark row. If the month is higher it should be displayed in red. If it is equal or lower it should be in green. Any ideas?
Conditional formating
I am looking to compare the Month row to the Benchmark row. If the month is higher it should be displayed in red. If it is equal or lower it should be in green. Any ideas?
Also i would like it to be higher than a percentage of the benchmark for it to be colored red... any help would be appreciated
Hi and welcome to the forum.
Try this.
=B$15>B$16>> for red color.
Same for green.
Hope to helps you.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks