Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-21-2017, 01:30 PM
ravl13 ravl13 is offline Formula to format "I" column based on if "F" column row is not blank Windows 7 64bit Formula to format "I" column based on if "F" column row is not blank Office 2013
Advanced Beginner
Formula to format "I" column based on if "F" column row is not blank
 
Join Date: Nov 2012
Posts: 50
ravl13 is on a distinguished road
Default Formula to format "I" column based on if "F" column row is not blank

Hello,

I have an image to make my question easier to comprehend:



Based on whether the "F" column is blank or not for any row, I'd like to have the "I" column set to have dark blue text.

So, since the row for account 7008 is in the F column, I'd like the I column for that row to be made blue. Since the row for account 7008D has a blank F column (The value actually stored in column G), I'd like that same row for column I to be untouched.

Can someone clue me into a formula I can put into Excel 2013's "Use a formula to determine which cells to format" functionality to make this happen? Thanks.
Reply With Quote
  #2  
Old 08-21-2017, 01:41 PM
NBVC's Avatar
NBVC NBVC is offline Formula to format "I" column based on if "F" column row is not blank Windows 10 Formula to format "I" column based on if "F" column row is not blank Office 2013
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enough
Default

Assuming you are selecting from I2 down...

=AND($F2<>"",LEFT($F2,5)<>"Total")


This should colour column I if F is not blank and it is not a Total row...

If you want Total row coloured, then simply use

=$F2<>""
Reply With Quote
  #3  
Old 08-22-2017, 12:23 PM
ravl13 ravl13 is offline Formula to format &quot;I&quot; column based on if &quot;F&quot; column row is not blank Windows 7 64bit Formula to format &quot;I&quot; column based on if &quot;F&quot; column row is not blank Office 2013
Advanced Beginner
Formula to format &quot;I&quot; column based on if &quot;F&quot; column row is not blank
 
Join Date: Nov 2012
Posts: 50
ravl13 is on a distinguished road
Default

Thanks so much, that does what I want it to. You're awesome!
Reply With Quote
  #4  
Old 08-22-2017, 12:26 PM
ravl13 ravl13 is offline Formula to format &quot;I&quot; column based on if &quot;F&quot; column row is not blank Windows 7 64bit Formula to format &quot;I&quot; column based on if &quot;F&quot; column row is not blank Office 2013
Advanced Beginner
Formula to format &quot;I&quot; column based on if &quot;F&quot; column row is not blank
 
Join Date: Nov 2012
Posts: 50
ravl13 is on a distinguished road
Default

Thanks so much, that does what I want it to. You're awesome!
Reply With Quote
Reply

Tags
conditional formatting, formatting, formulas

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to format &quot;I&quot; column based on if &quot;F&quot; column row is not blank Count # of times "text" is in 1 column is specific date is in the other column ann.acornacchio Excel 4 12-31-2016 05:40 PM
Need help with conditional formatting & returning "Pass" / "Fail Results" in a Column N mikey386 Excel 2 12-11-2014 01:14 PM
How to edit the "Format" and the "show level" of an EXISTING table of content? Jamal NUMAN Word 2 08-14-2011 10:46 AM
Formula to format &quot;I&quot; column based on if &quot;F&quot; column row is not blank "Table of content" based on "Normal Style" behavior!!!! Jamal NUMAN Word 4 07-08-2011 04:12 AM
Formula to format &quot;I&quot; column based on if &quot;F&quot; column row is not blank Why the "table of contents" doesn't take the same format of the "headings"? Jamal NUMAN Word 5 06-15-2011 10:14 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 10:48 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft