LinkBack URL
About LinkBacks
I want to change the color of one row (A-F) when a certain condition in column C is met. Example when cell C5 is equals to "Available", the A5 to F5 cell color should be changed. Same on column F once a value exceeds 6.00.automatic formatting.xlsx
I want to change the color of one row (A-F) when a certain condition in column C is met. Example when cell C5 is equals to "Available", the A5 to F5 cell color should be changed. Same on column F once a value exceeds 6.00.automatic formatting.xlsx
Hi. See sample file.
Please * if you like the answer
Look at this link on conditional formatting
http://www.techonthenet.com/excel/qu...rmat4_2007.php
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
try this, look into the conditional formatting function to see how it was done.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Please see attached file
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thank you AlKey for the response, the file you attached is working succesfully however. i would appreciate a step by step for me to have a knowledge and also to apply formatting to my other files.
miss_chole, since AlKey is offline now, he did it the same way I did it but he caught the one condition I missed. You go to the "Home" tab and under styles select "conditional formatting", then click on "new rule" and for the months deployed column (F) you select format only cells that contain cell value in the edit rule description and greather than and 6, then the format button and select the fill tab and the color you want then ok, ok and apply.
For the colored blue rows select you select "new rule" to add an additional rule, then "use a formula to determine which cells to format and I used =$C2="available" and copied down all the rows.
Hopefully that's clear.
EDIT: BTW, you can give kudos (* add reputation) to any (or all) who helped you so don't forget to give to AlKey, and if your pblm is solved don't forget to mark the post as such.
Last edited by Sam Capricci; 10-02-2013 at 09:00 AM.
Hello miss_chloe,Originally Posted by miss_chloe
1. The formula for the Blue colored cells: =($C2:$C$16="Available") . The important part is $C2 the number 2 is not absolute but relative.
Apply to area should be =$A$2:$F$16. This the entire range of the table.
Hope this hellp
Also I am very glad that we could help. Please don't forget to thank those who helped by clicking on Add Reputation * and please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).
Thank you AlKey and SamboKid for the help, the blue cell color formatting is ok. But the orange cell color when cell is equals or greater than 6, im still stuck. Im on the Conditional Formattin Rules Manager windows and i already have a rule for the orange cell
and it applies toFormula:
Please Login or Register to view this content.Formula:Please Login or Register to view this content.
but its not working.
Click on conditional formatting >> manage rules >> select the rule for the orange formatted rule and click on edit rule, change the rule from "equals to" to Cell Value "greater than or equal to" and leave it as =6 and that should work, click ok then ok or apply. Should work for you.
Thank you Sambo kid. i figured it out. it works fine.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks