If I apply conditional formatting to say cells A6:A20 then that works ok.
But as I have 20 columns it would be easier to do all 20 at once by highlighting them.
However it is every other column that I need to do.
Example:
A6:A20
C6:C20
E6:E20
When I highlight the 3 columns cells 6:20 the conditional formatting doesnt work.
Would this be correct or am I doing something wrong?
thanks
Please upload your excel file for better help.
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
Excel file....
test PO.xlsx
I get an error while opening the file
Can you try it again.
File
test PO.xlsx
I still get an error
It opens ok this end , the actual sheet and also from the forum link. I also emailed to myself and it opened ok from that.
Dont know what else to try.
Someone else got problems with downloading?
In the meantime I have managed to find a quick method by using format painter. I wasnt aware I could use this as a copy/paste function.
YesOriginally Posted by popipipo
_______________
Dave
What is the cf rule?
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
The rule i am using for
=a8:a25<$W$27 format to white text. This works ok.
My question was if I could CF all at once the same for say columns C,E,G,I,K etc. so that I didnt have to CF each column seperately.
I solved it by using format painter to copy/paste which speeded things along.
Select E6:K23 and go to Conditional Formatting, New Rule, use Formula.... and enter this formula
Formula:
Please Login or Register to view this content.
Apply WHITE as the font colour.
Make sure that the APPLIES TO range is correct and click APPLY.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Thanks newdoverman, I have to update that particular page tomorrow evening when it is returned to me so will give your CF recommendations a go.
I will post back and let you know how it goes.
Thanks
If your real data occupies the same columns and follows the same pattern, select the data that you want to apply the formatting to and enter the formula and it should work. Your example has two columns together K and L that interrupts the pattern and the formatting will not cross that properly.
Last edited by newdoverman; 07-05-2015 at 05:47 PM.
The real data is every other column so I should be ok, but thanks for spotting that and giving a correction
Can I ask though (assuming you know the answer) why my excel uploads have not worked for other users yet you appear to have got them working. is it something I have done incorrectly when posting?
I had edited the response and removed the formula but here it is again if required. If the Conditional formatting is applied to the wrong column, change the =0 to =1.
Formula:Please Login or Register to view this content.
As for the problem with uploaded files. I have noticed that some people have reported problems such as you mention. I think that this is a problem with the site or possibly the security settings of the downloader. If you successfully upload your intended file then, you have done it correctly.
I can't give you a definitive answer as to why as there are many possibilities.
PNG files are a problem for people using Internet Explorer. I am one of those.
Good luck with your real data.
Last edited by newdoverman; 07-05-2015 at 07:03 PM.
OK that formula worked perfectly.
thank you
Thank you for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks