Hello Forum,
I have searched high and low for guidance on this problem but can not quite solve it.
I am trying to format a cell (G:G) based on if cell range (F:F) displaying dates is in the past and the cell range (G:G) displaying status reads 'pending'.
I hope that makes sense
Regards,
Tom
Last edited by Clark85; 04-09-2013 at 07:46 AM.
=and($f1<today(),$g1="pending")
Something like this in Conditional Formatting rules?
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.
This conditional format formula in cell F11 and paste down
Please Login or Register to view this content.
Elegant Simplicity............. Not Always
Hi Clark85
Try the following for the conditional formatting rule.
Formula:
Please Login or Register to view this content.
Regards Kevin
Merged Cells (They are the work of the devil!!!)
Hello Fotis, Thanks for the help.
I thought it had worked originally however as you can see it has formatted random cells... if you can see the attached image I am trying to format the cells that say pending relation to the cell to the left if it is in the past
Thanks Kevin works a treat.
As you are dealing with dates, a small sample sheet would help more than a picture, however colorful.
=and($f2<today(),$g2="pending")
BTW INT(NOW()) is the same as TODAY()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks