LinkBack URL
About LinkBacks
I would like to have my rows be filled when a certain word contain in a cell.
For example, in D3, it has a value true then the row under D3 be filled with color green. If none, its just blank.
TIA,
How to fill a certain row cell
I would like to have my rows be filled when a certain word contain in a cell.
For example, in D3, it has a value true then the row under D3 be filled with color green. If none, its just blank.
TIA,
So just to be clear, if D3 contains "true" you want the entire row 4 to be green? And if so, can D4 also contain True which would make row 5 green?
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
In Conditional Formatting rules, use this ..formula..
=d3=true
Fix the range according your needs..
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.
Yes, but i would like to when D3 contains "true" the entire row 3 be green/any color, then when D4 contains "true" then entire row 4 be green then so on. Then when contains none, then it will just be plain. :DOriginally Posted by Sambo kid
What Fotis1991 wrote looks like the way to go.
Working on it using conditional formatting seems like the only way to go.
I've been doing it row by row and have it working but I'm going off your second post. Using conditional formatting I put true or false in col D. Then go to conditional formatting and use a fromula to determine which cells to format, click on the formula bar, =$D7=True, applies to =$7:$7 and ok. Colors the whole row as green.
Colors the whole row as green. (Provided when you're under the "Format Cells" section you click on the Fill tab and select your colors.)
I did get your ideas and tried it but its not what I meant about my post above :D it only colors single row and I have to apply the formula in each row...
Here's what I want to achieve, I attached an excel file for you guys to check and advise me how am I going to do this :D thanks guys!
1. highlight the range you want to apply the conditional formatting to (A2:G12)
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =$F2=TRUE format fill the color you want
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks