Please help - I'm trying to set conditional formatting [Excel 2007] on a stock control worksheet that will set colour dependent on matching criteria in two cells. If cell A3 has text and cell F3 is blank I want the colour in cell K3 to be green; if cell A3 and cell F3 both have text, I want K3 to be red. Hope someone can help, I've spent hours trying lots of variables!!!
And(F3="",A3<>"").......................Green
And(F3<>"",A3<>"").......................Red
Elegant Simplicity............. Not Always
try
=and(istext($a3),$f3="") >>for green
=and(istext(a3),istext($f3)) >>for red
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.
Thank you...so any clever people out there
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks