How do I set a conditional formatting? Thanks Michelle

in lotus 123 there was a useful / often used conditional formatting (by background colour) of unprotected cells for data input. This s/be top of chain of...

I struggle to apply a 'conditional formatting using formulas' to a range of cells. Can someone give me some education on that please?

this is probably a basic question, but here goes... I have a worksheet where staff will be slowly filling in dates into one column and I want Excel to...

Hi I've got the undernoted formula on my spreadsheet:- =IF(T3=R3,"No","Yes") Could someone tell me how to make the yes turn red in the cell Thanks

Excel 2003. Beginner user here. I have Cell C3 with a date and time. I have Cell D3 with a date and time. I want Cell C3 to become bold text if the date...

New to this.... I have a list of dollar amounts in column A. In column B, a 1 or 2 (yes or no) depending on whether the bid was awarded or not. I need to...

I have some cells which look like the following:- (they show three values from three other cells) either 1, 30, 5 or 1, *, 5 say where the "*" indicates a...

I am trying to automate the colour of a cell depending on a date. In cells A4:Z4 I have the weekending date starting at 08/01/2010 in A4, then A4+7 in B4 then...

Hello I want to set the 'fill' colour of a cell according to the data in that cell, so if the cell contains 1 it is filled red, 2 is blue, etc etc. No...

Hello, I have a spreadsheet with several rows of data. The first cell of each row contains a logical formula which equates to 'TRUE' or 'FALSE'. I want to...

I'm hoping someone will be able to assist. I have a spreadsheet that tracks hours. I need to be able to quickly identify if I'm close to or have reached a...

I currently have the following set up on an excel spreadsheet A B C D E F 1 DATE NAME ...

Hi, I asked a similar question and got a great answer, but now I have a more detailed question...This is what I want to do I just don't know how to write the...

My dear , how can i use more than 3 choices in conditional formatting , thanks. -- Message posted via http://www.officekb.com

I am putting together a spread sheet with many formulas that track employee performance. Not all formulas have values. Is there a way to Hide the formula in...

I have a rather large worksheet that will have hundreds of cells with conditional formatting. Most of them are the same (only the cells and value ranges...

I'm new to conditional formatting, and only have Excel 2003. I don't have a problem getting my 3 desired rules entered and functioning. Red if a value...

how can accomlish this task? When I type text in column A, it appears in column B automatically in the following format, see below: column A babc...

Hi I run Excel 2K Conditional Formatting in Excel 2K only allows three conditions to be applied. I need 8 conditions. What I have is 8 check boxes that...