Conditional Format Problem

Dan, on Wednesday June 11, 2008 03:43:21 PM

Hello,

I want to use Excel Conditional Format to change color of an entire row whenever there is a "cancel" placed in any of the cells in that row. All other information involves taking a value from a column entry, and not a row entry.

We have daily updates and whenever a cancellation is entered in the daily log [which is in row format] I want the entire row to change color.

Can anyone help?

Thanks.

Configuration: Mac OS X
Safari 525.18

Reply to Dan Report this message to moderators

Results for Conditional Format Problem

Conditional Formatting with expiry dates Hello, I am working on a large excel spreadsheet full of training records. I have managed to use conditional formatting to highlight when a course has expired. However I am struggling to highlight when a course is due to expire within 3 months of... en.kioskea.net/forum/affich-20294-conditional-formatting-with-expiry-dates

Conditional Formatting I need to specify different text colours for certain conditions. This I can do with the conditional formatting but only for three conditions, I have tried to write some VBA code to allow me to call two or more routines to get more conditions The code... en.kioskea.net/forum/affich-26380-conditional-formatting

Conditional formating - apply on more cells Hello, i'm not so familiar with conditional formatting, so i would like to ask something: I'm making a doc where Column A has number values, column B also numbers, of rank positions. Conditional formating of cell in column B would be: if... en.kioskea.net/forum/affich-41481-conditional-formating-apply-on-more-cells

More answers

Results for Conditional Format Problem

Colouring cells on conditionsColouring cells on conditions There are many pratical functions under Excel which is not commonly used. Example: If you wish a cell automatically turns red (or other formatting border, frame etc) under one condition: a result, a... en.kioskea.net/faq/sujet-956-colouring-cells-on-conditions

Formatting Your Hard DriveFormatting Your Hard Drive Formatting and installing your Hard drive using the installation CD ] A hard disk drive is a non-volatile device mainly for data storage. Usually faster than any other storage device, this essential... en.kioskea.net/faq/sujet-194-formatting-your-hard-drive

Formatting your Flashdisk (USB Key )Formatting your Flashdisk (USB Key) How to format your USB Key? It is compulsory to format your USB Key regularly if you are frequently performing File transfer to one computer to another. Your computer can get infected with potential... en.kioskea.net/faq/sujet-186-formatting-your-flashdisk-usb-key

More answers

Results for Conditional Format Problem

More than 3 conditional formatsHello, I am using Excel 2003. I need to include more than three Conditional formats (CF) for creating a grading sheet. The grading scale is 1-4. For example: When a 1 is entered, the cell will change color, 2 change a different color, 3, and so on.... en.kioskea.net/forum/affich-40690-more-than-3-conditional-formats

Conditional Formatting on dateHello, I am trying to conditional format a document. I have a document that has target dates in the K3:K171 position. I am trying to format the entire line red if the target dates is not met unless teh completion percent in M3:M171 states 100%. Your... en.kioskea.net/forum/affich-45528-conditional-formatting-on-date

Conditional formatting problemsHello, I have a office 2003 instalaltion and none of the conditional formatting is working. I also created a new sheet and applied conditional formatting but the cells stays as is. No formatting is applied. en.kioskea.net/forum/affich-13623-conditional-formatting-problems

More answers

Results for Conditional Format Problem

Download HDD Low Level Format ToolIt is administrator's free application of hard disk. It is quick and easy to use. He allows to format and of partition discs including flash.It supports discs: SATA, IDE, S-ATA (SATA), IDE (E-IDE), SCSI, USB, FIREWIRE, LBA-48 and even the external... en.kioskea.net/telecharger/telecharger-815-hdd-low-level-format-tool

Download HP USB Disk Storage Format ToolHP USB Disk Storage Format Tool is a small utility allowing to format a key USB or READER MP4. It also allows to make a key (Bootable). This software works with all keys and readers MP4 of the market. To make work this utility under Windows... en.kioskea.net/telecharger/telecharger-127-hp-usb-disk-storage-format-tool

Download Switch File Format ConverterSwitch is an utility of audio conversion for Windows. Switch is very easy to use. It is enough to add the file to convert in the list, to choose desired format and to clicker conversion on the button.It inserts a simple and intuitive interface. The... en.kioskea.net/telecharger/telecharger-785-switch-file-format-converter

More answers

Results for Conditional Format Problem

General Terms and Conditions of Use All Rights Reserved - 2007 - Quid�a Object These General Terms and Conditions are meant to define the ways in which the services of the website en.kioskea.net, hereafter "The Service," are made available, as well as the conditions of use of the... en.kioskea.net/ccmguide/cgu-conditions-generales.php3

Formatting a hard disk Before trying to understand formatting, you first need to understand how a hard drive works. Many people do not distinguish low-level formatting (also called physical formatting) from high-level formatting (also called logical formatting). Even... en.kioskea.net/repar/format.php3

Video and digital imaging - The GIF format The GIF format (Graphic Interchange Format) is a bitmap (raster) graphic file format developed by Compuserve. There are two versions of this file format developed respectively in 1987 and 1989: GIF 87a supporting LZW compression, interlacing... en.kioskea.net/video/format-gif.php3

More answers