|
|
#1
10-27-2015, 10:24 AM
|
|||
|
|||
Create formula for entire column
I want to make an have an entire column formatted with a conditional formula. Column K is conditional on whatever is in column J. The thing is I want the entire column to be formatted Only if it has a date inside. What I have not keeps formatting cells in K when J has nothing in it.
Conditional formatting Rule 1: =TODAY()-J2=30 with Text Red Rule 1: =TODAY()-J2>30 with filler Red I want to continue that formatting but not if the date column is blank. I was thinking the way to do this is with the following formula. =IF(NOT(ISBLANK($J1))) It says error though ???? 
|
|
#3
10-27-2015, 09:38 PM
|
|||
|
|||
|
@tdodson
If you were stuck on finding an answer to a problem and you finally found a site that looked like it might have an answer to your problem and you would see: "Never Mind. Figured it out", would you be impressed?
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Need help with dragging a formula and changing a reference column as I drag the formula. | LupeB | Excel | 1 | 10-22-2015 03:02 PM |
| How to add a fixed value to an entire column? | mikehende | Excel | 11 | 12-12-2012 02:47 PM |
| formula to work from data column | masterdineen | Excel | 16 | 08-09-2012 07:52 AM |
| NETWORKDAYS calculation for entire column | Salient | Excel | 0 | 07-11-2011 03:58 PM |
| Formula not getting copied to entire column | theacegary | Excel | 1 | 11-29-2010 02:18 PM |
Create formula for entire column
Windows XP 
Office 2013
Linear Mode
