Home |
Search |
Today's Posts |
#1
|
|||
|
|||
If is blank= conditional formating
Hello
I was trying to make a formula to conditional format a cell. I wanted the formula to be (if the cell is blank). I wanted to make the cell have a red border if it was blank. I know how to make make the border red if the condition is true, but im not sure how to write the formula for this. Thanks for your help. |
#2
|
|||
|
|||
=$A$1=""
HTH Jason Atlanta, GA -----Original Message----- Hello I was trying to make a formula to conditional format a cell. I wanted the formula to be (if the cell is blank). I wanted to make the cell have a red border if it was blank. I know how to make make the border red if the condition is true, but im not sure how to write the formula for this. Thanks for your help. . |
#3
|
|||
|
|||
Thanks for your answer it was of great help.
I found something rather hard though, I cant copy the formula to other cells, I wanted a whole row to use this formula, but if I copy a cell to others it doesn't change the formula to correspond with the new cell, its leaving the cell # the same. Thanks for your help. "Jason Morin" wrote: =$A$1="" HTH Jason Atlanta, GA -----Original Message----- Hello I was trying to make a formula to conditional format a cell. I wanted the formula to be (if the cell is blank). I wanted to make the cell have a red border if it was blank. I know how to make make the border red if the condition is true, but im not sure how to write the formula for this. Thanks for your help. . |
#4
|
|||
|
|||
Hi Mark,
see http://www.mvps.org/dmcritchie/excel/condfmt.htm you probably want to use a formula like =A1="" or perhaps =TRIM(A1)="" if A1 is the active cell in your selection when you do the Conditional Formatting. $A1 would be good for coloring the entire row based on the cell in Column A. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Markitos" wrote in message ... Thanks for your answer it was of great help. I found something rather hard though, I cant copy the formula to other cells, I wanted a whole row to use this formula, but if I copy a cell to others it doesn't change the formula to correspond with the new cell, its leaving the cell # the same. Thanks for your help. "Jason Morin" wrote: =$A$1="" HTH Jason Atlanta, GA -----Original Message----- Hello I was trying to make a formula to conditional format a cell. I wanted the formula to be (if the cell is blank). I wanted to make the cell have a red border if it was blank. I know how to make make the border red if the condition is true, but im not sure how to write the formula for this. Thanks for your help. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formating | Excel Discussion (Misc queries) | |||
Help using Conditional Formating of Entire Rows | Excel Worksheet Functions | |||
more than 3 conditional formating in excel | Excel Discussion (Misc queries) | |||
Conditional Formating when result is text | Excel Worksheet Functions | |||
30 Day Aging Report Using Conditional Formating | Excel Worksheet Functions |