Hi
I have a requirement to colour the cell background based on each cell value.
Attached the sample file with conditions at column (A,B,C).
Column H in the file to be coloured.
Note: The number of rows in column H is dynamic.
Hi
I have a requirement to colour the cell background based on each cell value.
Attached the sample file with conditions at column (A,B,C).
Column H in the file to be coloured.
Note: The number of rows in column H is dynamic.
Use a dynamic named range for column H, then use conditional formatting.
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Hello
No need of VBA here. Only Conditional formatting.
1 rule(for yellow)
Formula:Please Login or Register to view this content.
Same way for the others.
How can you use Conditional Formating.
--In Excel 2007 and 2010, Conditional Formatting is in the Styles group on the Home tab. In Excel 2003, Conditional Formatting is on the Format menu. See here how you can work using CF.
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.
Nathansav
Thanks! the problem is i want this run in 2003, 2007 and 2010.
Conditional format cannot be provided for 5 in 2003.
non vba solution.
solution with Vlookup, see the attached file.
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.
For 5? What do you mean?
Hi you just need to highlight the column and select conditional format option in the home tab and select new rule choose format cells that only contain repeat this step for each condition
nathan
If you look in to the number for conditions it is total 5.
I want to loop thru all the 5 conditions in column H and apply colour index based on the conditional colours.
oeldere
I want to colour the same column H.
Yes i did notice that, but I thought my solution could be useful to you.Please Login or Register to view this content.
What are you gonna do, with the colors, after they are in your file.
Just for visual purpose, or you want to analyze data with the colors?
please reply.
Hi Oeldere
It is basically for analysing data so colour is very important.
Oeldere
Any Luck? I'm not sure how to use between operator to check the conditions
And how you gonna use the color for analyzing in excel 2003 (see you comment #4)?Please Login or Register to view this content.
So it is NOT just for visual purpose?
Oeldere
The column H values will be used for other sub routines which reads based on the colour thats why im trying to colour column H
It stays misty around this case.Please Login or Register to view this content.
Please explain better.
Second question:
the subroutine is VBA or formula?
Oeldere
Sorry if its not clear.
What im trying to achieve is to check the column h values by the 5 coditions provided in column ABC.
If the value in column H satisfies any of the 5 conditions then it should updated with background colour of the specific condition.
The colours are then read by downstream apps which includes VBA as well as some web application as well.
I am not able to see #16, since the page don't change from page 1 to page 2.
i can navigate to page 2
Hi
Can anyone help to resolve this?
stuck with this part to colour the cells.
If you also want to use it in excel 2003 you have to rely on VBA since CF in excel 2003 only except 3 criteria.
yes, thats why i need help from experts to write a loop to check all the 5 conditions.
Any hint will be really helpful.
Hi
Can any one help to resolve this query?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks