LinkBack URL
About LinkBacks
The attached worksheet explains the problems I’m having.
In addition, is it possible to copy and past conditional formats without it referencing the original cell?
Format Help.xlsx
The attached worksheet explains the problems I’m having.
In addition, is it possible to copy and past conditional formats without it referencing the original cell?
Format Help.xlsx
Try this
=AND($D8>0;$D8<$E8;$F8="")
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.
thats working for every exception apart from:
if the date in in Cell E8 is before the date on the cell E2 the conditonal format is still turning red. i need it to remain no functioning until it is beyond the =today() formula date as it wil lbe a date sensitive tracker??
(Thanks for the help btw)
This one?
=AND($E$2>$E8,$D8>0,$F8="")
nope!
not yet...
It's must be something that i don't understand..Let's try this one.
=AND($E$2<$E8,$D8>0,$F8="")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks