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 09:36 AM.
Use =$A1>$B1 (for green) and =$A1<$B1 (for red) in conditional formatting: Use formula to determine which cells to format
"Relax. What is mind? No matter. What is matter? Never mind!"
Hi
In conditional formatting rules, in C1>>>=a1>b1 >> GREEN COLOR>>>ok
C1>>>=A1<B1>>>>RED COLOR.>>>OK
hOPE TO HELPS YOU.
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
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.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks