K
kpkammer
Is there a way to apply this to an entire row or range?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
In Excel, conditional format (font red) referencing another cell?
G
Gord Dibben
Pre-select the range before formatting.
Gord Dibben MS Excel MVP
Gord Dibben MS Excel MVP
B
Bob Umlas
Select whole row and use absolute reference to formula, like =$B$1="Your
text"
Bob Umlas
text"
Bob Umlas
B
Baz
Has to be said, Conditional Formatting in Excel 2007, whilst it might offer
more features, is alot more complex and counter-intuitive than in Excel 2003.
more features, is alot more complex and counter-intuitive than in Excel 2003.
J
Jamie
I have a similar issue. I have a spreadsheet where column C contains a list
of sales reps initials and the row is conditionally formatted so each set of
initials fills the cell with a specific color. ME is blue, SC is green, etc.
What I need is for Column A to match the conditional formatting in Column C
for the entire row. I know how to do it one cell at a time, but that will
take entirely too long!
of sales reps initials and the row is conditionally formatted so each set of
initials fills the cell with a specific color. ME is blue, SC is green, etc.
What I need is for Column A to match the conditional formatting in Column C
for the entire row. I know how to do it one cell at a time, but that will
take entirely too long!
S
Siagian
Valko and experts,
I am facing the same in my worksheet. I did this and it is only for one
cell. I would like to do the same for about 500 cells which is referred to
another cell(s) but put the formula on every cell will consumed alot of time.
I tried to copy and paste the format but it wont change the cells reference
like if we copy a formula from a cell to another cell(s). Please help to
resolve this. I would happy if you also recommend alternatives.
Thank you
I am facing the same in my worksheet. I did this and it is only for one
cell. I would like to do the same for about 500 cells which is referred to
another cell(s) but put the formula on every cell will consumed alot of time.
I tried to copy and paste the format but it wont change the cells reference
like if we copy a formula from a cell to another cell(s). Please help to
resolve this. I would happy if you also recommend alternatives.
Thank you
S
SusanS
SteveG - Thanks for the information. Is there a way to do this on a range of
data in Excel 2007? I find that I am having to do each row individually. Is
there a faster way to do this? Thank you for your help with this!\
Susan
data in Excel 2007? I find that I am having to do each row individually. Is
there a faster way to do this? Thank you for your help with this!\
Susan
B
Bob Umlas
Select the whole range and use =$B1="Your Text" instead of B1
S
SusanS
Thank you. This worked PERFECTLY!
Bob Umlas said:Select the whole range and use =$B1="Your Text" instead of B1
.
A
Anaida
SteveG said:Christine,
Yes. In A1 go to Conditional Formatting. Change the Cell Value is
option to Formula is. Enter
=B1="Your Text"
Click Format, Font select the color you want. Click OK, OK.
HTH
Steve
I need help in doing something similar. I would like to have the font in a
specific cell turn red if the value of that cell is greater than another
cell. For example . . .
In A1, I have 4000. In A2, I have 5500. I want to subtract A2 from A1. If
the result is negative, I want the font in the cell with the result to be
red. Can you please help me? Thank you.
I've tried all the suggestions in this forum, but non has worked for me.
Thank you.
G
Gord Dibben
Formula in A3................=A1-A2
Select A3 and CF Formula is: =C1<0
Format to red font.
Gord Dibben MS Excel MVP
Select A3 and CF Formula is: =C1<0
Format to red font.
Gord Dibben MS Excel MVP
L
LorieK
Thank you SteveG!!!
I am so grateful for your help.
Lorie
I am so grateful for your help.
Lorie