I am trying to change the font color in one cell if another cell has a certain value. The values range from 6 to 12 and each value requires a different color. I have 27 rows to do this for so I was wondering if there was a better way to go about this than creating 189 conditional statements. I am using Excel 2007 on a PC.
You need only 7 conditional statements and fix your range ...
Something like this.
=$B1=1>>color a
=$B1=2>>color b
=$B1=3>>color c
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