I've got a few hundred rows of data in 4 columns, 3 of which are values. I'd like to put a 3-color scale on the values for each row to show the min/mid/max. I can't seem to figure out the formula in conditional formatting. Anyone have an idea? Data is in A1:D738 w/headers. Thanks
Assuming that your range with numbers is D6:F11, YOU NEED 3 RULES IN CONDITIONAL FORMATTING RULES.
Use max & min funtions for maximum and MINIMUM VALUES AND USE THIS ONE FOR THE MID.
=AND(D6<>MAX($D$6:$F$6),D6<>MIN($D$6:$F$6),D6<>"")
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.
ahh, that makes sense thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks