Good day.
I want to copy (or drag and drop) the formulas in a cell with conditional formatting to other cells but the formulas does not change like for example normal IF formulas do if you drag and drop them. Even if I remove the $ sign in the formula it changes it back as soon as you exit the conditional formatting tab.
Can anybody please assist?
add the excel file on the forum.
I can't see (or open) what you added.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hi, welcome to the forum.
Have you tried using the 'Format Painter' button?
Regards,
Aardigspook
I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
You don't need to give me rep if I helped, but a thank-you is nice.
Many members are unable to see images in the *.png format due to forum compatibility issues with some browsers.
If you need to post an image post it in the *.jpg format.
The easiest way to apply CF is to select the ENTIRE range and do it in a single operation.
You have to get the cell references correct.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Let me try again.
Can anybody assist, please?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks