LinkBack URL
About LinkBacks
Is it possible to copy the conditional formatting from one cell to another without removing the contents of the cell?
Is it possible to copy the conditional formatting from one cell to another without removing the contents of the cell?
Last edited by Ltat42a; 10-01-2012 at 12:16 PM.
Yes it is.
Which is the rule?
Which are the ranges?
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.
Select the Cell you want to copy from. Right click with your mouse > click on Copy> select destination Cell> Right Click on your mouse> Click on "Paste Special" > then Click on "Formats" > Click on O.K.
You may have to edit the conditional format formulas to suit your requirements.
Last edited by Winon; 10-01-2012 at 10:00 AM.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
A2 is =WORKDAY($C$1,D1)Originally Posted by Fotis1991
C1 is =today()
D1 is 1
Column A range is A2:A211
Do you also use range C2:C21 AND D2:D23 with data?
Which is the rule in Conditional Formatting? =WORKDAY($C$1,D1)
You mean something like this?
=WORKDAY($C1,$D1)
No, not using the C or D column (except C1 & D1).
The conditional formatting I'm using is =IF(AND(A2=TODAY()),IF(B2<>"",TRUE,FALSE))
Why don't you just adjust the range in C.F rules to A2:A23?
If_agai_)did not get it, pls, upload a small sample workbook.
Huh? Not sure what you mean here.
Let's hope that i get it.
iN b37 IN c.f RULES YOU HAVE ONE FORMULA. sAME FORMULA YOU WANT TO COPY TO ALL THE RANGE IN COLUMN b..
Is this?
another way is to copy/paste formats
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
@ FDibbins,
Hallo my vriend,
That is what I also said in Post No.3. I'll have a look at the WorkBook now.another way is to copy/paste formats
Bly in kontak!
Can you please add another sheet to the WorkBook, showing us what exactly how you want to achieve what?
Column A & B seem to be doing what it should. How do you want to implement changes and where?
Check out the attached WorkBook, and you will see that as the date changes, and you enter a value in the appropriate Cell in Column B, the Cell in Column B changes to Yellow. A day later that very same cell will revert back to no interior color.
Got it, Thank you.
Hi Ltat42a,
You are welcome!
You are welcome!
Thanks for the reb*
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks