#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
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<>"" |
#3
|
|||
|
|||
Thanks so much, that does what I want it to. You're awesome!
|
#4
|
|||
|
|||
Thanks so much, that does what I want it to. You're awesome!
|
Tags |
conditional formatting, formatting, formulas |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
"Table of content" based on "Normal Style" behavior!!!! | Jamal NUMAN | Word | 4 | 07-08-2011 04:12 AM |
Why the "table of contents" doesn't take the same format of the "headings"? | Jamal NUMAN | Word | 5 | 06-15-2011 10:14 AM |