Hi
I need to change the fill colour in the range AH1 : BD1 in row 1 based on the fill colour I use in A1, so that as I change
the fill colour in A1 then the same colour fills AH1 to BD1.
Can anyone please give me some advice or a conditional formula that I can use to do this.
Many thanks
Mikey
Hi Mikey7346,
I am not sure if that can be done using conditional formula.. I guess the only solution is VBA (macros). thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
Hi Dilpandey,
Not so simple then. I wanted to copy the formula used in AH1 to BD1 to apply to other other rows of my worksheet!
Looks like I will have to continue with my manual fill.
Thanks
Mikey
Earlier you wanted to copy the fill color from A1 to this range.. .
and now, you said that ..
you want to copy the formula used in this range to apply to other rows of your worksheet...
Anyways, both of these actions requires macros (vba).Thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
Hi DILIPandey,
Yes originally I just wanted a formula, then I would have been able to copy and paste to other sections of the worksheet.
Sorry if I misled you, I should have been more precise.
Regards
Mikey
No problem
So what is your requirement now? Thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
Hi DILIPandey,
Was hoping there was a conditional formula solution and didnt really want to go down the macro route so think will continue with my manual fill.
Many thanks, I appreciate that you have tried to help.
Best regards
Mikey
are you using CF to change the color of te 1st set of data? if you, you could probably use the samew criteria through CF to change color of the 2nd set of data?
perhaps upload a sample workbook?
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
Hi
Have attached my sample worksheet as suggested. There is no conditional format in the choice of colour and the choice is arbitrary and is normally based on the crew leaders football team colours!
I was adding columns into the worksheet today and copying the formulae from row 59 into rows 61 to 65 As I was adding colour to the newly formatted rows I wondered if there was a way to automate the colour in the row based on the colour I had chosen in Cells A61 to A65,(but at the same time to keep the number format). Sorry DILIpandey this is a bit different to my original question but was hoping there was a simple formula I could use then copy and paste to the relevant section of my worksheet.
Regards
Mikey
in 2007, i dont believe there is any function to identify cell colors for use in other functions, unless you want to go the VBA route
Hi
Am now using excel 2010 if that makes a difference but dont really want to go down the macro route.
However as a last resort what would happen if I were to add a working hidden column in B and insert a 1,2,3,4.5 cells B61 to B65 adjacent to the crews and used that as my criterion to change the row colour. Would it then be possible to have a conditional formula to say if
B61 is 1 then make A61 blue and I61 to BO 61 blue, and again if B62 is 2 then make A62 orange and make I62 to BO62 orange etc etc.
Thanks
Mikey
Yes.. that seems to be possible.
But how these numbers i.e. 1,2,3,4,5 etc will be changed ? will you change these manually or through some formula ? thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
Hi Dilipandey
No, initially I would change manually and if I add a crew would go to No 6 with a different colour.
Regards
Mikey
Hi Mikey7346,
Basis your post#11, below is the solution which you can further customize as per your needs.
conditional formula to fill colors.xlsx
Go to conditional formatting window to see the logic / formula used .. thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
Hi Dilipandey
Sorry for not getting back on the forum to thank you for sorting out my query
Thanks again.
Best regards
Mikey
You are welcome Mikey...
cheers
Regards,
DILIPandey
<click on below 'star' if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks