Workbook1.xlsx
I currently have 2 conditional formatting formulas from columns B-J. When J is overdue, columns B-J turn red. When J is coming up in the next 2 weeks, columns B-J turn orange.
Now I need columns B-J to go back to its original format and colours when a date is entered into column K. Is this also a conditional formatting? How can I do this?
Please help. Thanks.
you could use a 3rd condition with a formula to determine if k has a value
Regards
Sean
Please add to my reputation if you think i helped (click on the star below the post)
Mark threads as "Solved" if you have your answer (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [code]
Please supply a workbook containing example Data: It makes its easier to answer your problem & saves time!
Add an additional condition to the AND formulas you're using for your conditional formatting that says K#=""
# in the above being the row number.
If I've been of help, please hit the star
I tried that and it doesn't work! Thanks
Just put as first rule in Conditional Formatting rules, this one.
=ISNUMBER($K6)
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.
Awesome...thanks!
...............................
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks