|
|
|
|
2 |
108 |
|
|
conditional formatting by
MikeH
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...
|
|
3 |
156 |
|
|
Conditional formatting by
Vincent Tsebewu
I struggle to apply a 'conditional formatting using formulas' to a range of
cells. Can someone give me some education on that please?
|
|
3 |
236 |
|
|
conditional formatting by
Lorraine
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...
|
|
2 |
154 |
|
|
Conditional formatting by
Clare
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
|
July 5th, 2009 08:59 PM
by Clare
|
5 |
131 |
|
|
conditional formatting by
Linda RQ[_2_]
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...
|
|
7 |
194 |
|
|
Conditional Formatting by
JC
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...
|
|
1 |
108 |
|
|
conditional formatting by
Bob Matthews[_2_]
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...
|
|
2 |
132 |
|
|
conditional formatting by
Pete[_22_]
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...
|
|
4 |
157 |
|
|
Conditional formatting by
KRK
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...
|
|
2 |
135 |
|
|
conditional formatting by
KRK
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...
|
|
1 |
250 |
|
|
Conditional Formatting by
mds310 via OfficeKB.com
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...
|
|
1 |
89 |
|
|
Conditional Formatting by
Humpy
I currently have the following set up on an excel spreadsheet
A B C D E
F
1 DATE NAME ...
|
February 25th, 2006 04:02 PM
by Max
|
2 |
77 |
|
|
conditional formatting by
mrseje1
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...
|
November 2nd, 2006 03:54 AM
by Biff
|
2 |
77 |
|
|
conditional formatting by
tofimoon4 via OfficeKB.com
My dear , how can i use more than 3 choices in conditional formatting ,
thanks.
--
Message posted via http://www.officekb.com
|
|
1 |
144 |
|
|
Conditional formatting by
THFish
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...
|
October 9th, 2007 09:41 PM
by THFish
|
3 |
108 |
|
|
Conditional Formatting by
Scores
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...
|
|
1 |
121 |
|
|
Conditional Formatting by
Gdareos
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...
|
March 15th, 2008 07:42 PM
by Gdareos
|
3 |
75 |
|
|
conditional formatting by
Stranded N Iraq
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...
|
|
0 |
93 |
|
|
Conditional Formatting by
John Calder
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...
|
|
8 |
1,091 |