Just a quick one. In column A I have a list of targets. In Column B I have a list of actuals. What I need is if the actual is greater than the target, I want the adjacent cell in C to turn green, if its less than the target then I need it to turn red.
Any help would be appreciated.
Kind regards,
Om.
Last edited by omletto; 02-13-2012 at 10:36 AM.
Use =$A1>$B1 (for green) and =$A1<$B1 (for red) in conditional formatting: Use formula to determine which cells to format
Hi
In conditional formatting rules, in C1>>>=a1>b1 >> GREEN COLOR>>>ok
C1>>>=A1<B1>>>>RED COLOR.>>>OK
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
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks