Color Formatting

[Todd Nelson]

Two Questioins
1. What is the formula to use when you need cells in a column to switch text
colors if it is under a certain percentage. i.e. column "o" under 95%

2. Formula to change cell color of adjacents cells to yellow if between
0:06-0:10 seconds, red if over 0:11 seconds? ie. column c 0:07 seconds,
columns a-e = yellow.

thank you!!!

 

[Alan]

Not a formula in the cell but Conditional Formatting will do this very well.
Look it up in 'Help'
Regards,
Alan.

 

[jordun]

Hi Todd

You can't change formatting with formula.
But you can use Conditional Formatting (Format--->Conditional
Formatting). There you can control the format of a range (or individual
cell) according to its value or by means of a formula.

You can use, of course, Vba.

 

[Todd Nelson]

When I use the conditional formatting I am not able to find where I can color
adjacent cells as well, I can only color the one cell in reference

 

[David McRitchie]

See http://www.mvps.org/dmcritchie/excel/excel.htm
which cells get colored depend on which cells/columns are selected
based on you formula which is adjusted for each cell based on the active cell.
So your formula would use $ in front of the column letter to show /that/ that
column is the one to be tested.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

When I use the conditional formatting I am not able to find where I can color
adjacent cells as well, I can only color the one cell in reference

 

[Bob Phillips]

You select the adjacent cell and apply the same condition to it, referencing
the other cell.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

When I use the conditional formatting I am not able to find where I can color
adjacent cells as well, I can only color the one cell in reference

 

[David McRitchie]

Correction, see
Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm

If you do it as I mentioned you only have to apply the formula once
no copying.

See http://www.mvps.org/dmcritchie/excel/excel.htm
which cells get colored depend on which cells/columns are selected
based on you formula which is adjusted for each cell based on the active cell.
So your formula would use $ in front of the column letter to show /that/ that
column is the one to be tested.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

When I use the conditional formatting I am not able to find where I can color
adjacent cells as well, I can only color the one cell in reference

 

[Todd Nelson]

Ok, I am thoroughly confused by this. When using the format painter it is
encountering a problem because the cell values are different. I have a time
span in the 1st column, a number value in the 2nd and time in seconds in the
third. The painter automatically changes the cell format.

 

[Todd Nelson]

wow, this was a lot easier than I made it, thank you to everyone for helping
stupid me get this one figured out!

You select the adjacent cell and apply the same condition to it, referencing
the other cell.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

When I use the conditional formatting I am not able to find where I can color
adjacent cells as well, I can only color the one cell in reference