Hello,
I have no clue have to create a formula with conditional formatting that would do the following:
When the cells B92, B170, B248 are not empty then add a bottom border in the column B:O.
So if I enter some text in the B92 cell, I would need to have a bottom border in B92:O92.
Thanks,
Graig
Condtionall Formatting
Select the cells to be affected
Add New Rule
Use a formula to determine...
=(OR(B$92<>"",B$170<>"",B$248<>""))
format with bottom border
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Highlight the 3 ranges and use this formula in CF rules.
Formula:
Please Login or Register to view this content.
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.
Sorry for not getting back to you sooner! I was on vacation :D
Thank you both of you for your input. In fact after reviewing my file I would rather need the following: If I enter a "x" in the column A:A I would need to have a bottom border applied in the columns B:O.
Can you please help me?
Thanks,
Graig
Formula:Please Login or Register to view this content.
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.
It's very odd. I am using a table and for some reason it doesn't work everywhere in the document. Please refer the attachment
..........................
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks