Microsoft Excel - Conditional Formatting

Asked By Shaun Shaya
13-Dec-08 11:18 AM

Hi All,

I am trying to use conditional formating to only apply if the the adjacent cell is blank, and apply this rule to the entire column.  I would think the formula would be something like: =$B=isblank  or =$B=NotIsBlank.  Can anyone offer some advice?  Thanks.

i think you are trying  i think you are trying

13-Dec-08 01:24 PM

to check if the next cell is blank in each and every cell of that column:

ISBLANK($A2)=TRUE -- this formulae should be in Cell A1 so we are checking if the next cell i.e. A2 is blank or not copy this formlae in the complete cells of that column to find out and do that conditional formatting.

Conditional Formatting  Conditional Formatting

14-Dec-08 01:18 AM

I am trying to highlight only those cells, who's dates are past a certain defined time frame.  I am able to accomplish this using the conditional formatting feature.  However, I do not want t oapply this rule, if the cell to the right (adjacent cell in the adjecent column) has a date in it.

 

I attached a file, not sure if it comes through.  the only cell to be highlhghted is H19

try this example  try this example

15-Dec-08 01:38 AM
Go to Format/ConditionalFormat select Formula and insert this in the box =ISBLANK(C1) press the Format button, select Font and in the Colour box select Red, press OK

The dialogue box should look like this:

http://my.storenow.net?f=1304

It's a Word file
try this  try this
15-Dec-08 01:39 AM
For realtive addressing, remove the $ signs (you can leave the one on front of the C if you always want to refer to column C.
It may be easiest if you select all the cells in column A to which you want the formatting to apply, then select Format-Conditional Formatting and follow the steps Patrick gave, using:
=ISBLANK($C1)
as the formula, assuming your activecell is in row 1.
try this link  try this link
15-Dec-08 01:43 AM
http://en.allexperts.com/q/Excel-1059/cells-blank-change-format.htm

http://www.tech-archive.net/Archive/Excel/microsoft.public.excel/2007-03/msg01507.html
Create New Account
help
Need help with creating a due date formula in excel Microsoft Excel Hi all, I'm creating an Excel spreadsheet and in Column C I have entered in the date an issue was opened displays correctly. formula for column e = workday(c1, 60) You can change the colors using conditional formatting. Keep the cursor in cell d1. Choose format / Conditional formatting Choose cell value - is equal to - in the third dropdown type = today(). Then click will prevent the ugly #NUM! error when no data is entered Hi, Here is an Excel worksheet with all of the scheduled tasks that have to be completed at a department the formula down by double-clicking the fill handle. 4. Cool Trick: Set up a Conditional Format that will use three colors: • Tasks Due today in Green • Tasks Due tomorrow in
conditional formatting excel Excel I would appreciate some links on learning more about formulaes for conditional formatting - I find it very interesting and would like to know a wide range of things that it can do. thanks. S Excel Discussions Microsoft Excel (1) Excel (1) VBA (1) Devenshire (1) Formulaes (1) Constants (1) Bliengme (1) Hundreds (1) Try: http
Alert in Microsoft Excel Excel Hello, helpful people. I am not very familiar with Excel 2007, but I am gradually trying to become familiar. I will try to be clear not been completed by its due date. I appreciate any help you guys can give! Excel Worksheet Discussions Microsoft Excel (1) Excel 2007 (1) Eyesight (1) Equals (1) Guys (1) Use Conditional Formmating. Select your date cells
Conditional Formatting Excel Excel 2003 Can't select multiple worksheets at same time and use the conditional formatting tool. Is there a simple way of copying the conditional formatting to the other worksheets? Besides the format painter option. Excel Miscellaneous Discussions Microsoft Excel (1) Excel 2003 (1) Nadine (1) Goto (1) D49A64A56534 (1) Painter (1) Hinot (1) hi
Can I use AVERAGEIFS? Excel Excel Worksheet Discussions Microsoft Excel (1) Excel 2007 (1) Excel (1) ISNUMBER (1) AVERAGE (1) TEXT (1) Debug.Print (1) October (1) Try (in 2007 Enter. AVERAGE will automatically ignore cells with text strings. But if D3 is actually the Excel error #NA instead of the string "NA", you will need another term to ignore it this application. AND returns a single result where you need an array of results. - - Biff Microsoft Excel MVP Perhaps you could use: = 3DSUMIFS( . . . ) / COUNTIFS( . . . ) with the same conditional parameters in the