change font color based on value?

  • Thread starter Thread starter Mike Jacoubowsky
  • Start date Start date
M

Mike Jacoubowsky

Is there a simple way to test a column's content for its value (date) and
assign a color to the displayed date based upon a date range?

Yeah, I'm new to Excel; normally a database kind of guy (or would use
Crystal Reports and create formula fields that would display the date only
if it was within a certain range and assign a font & color to it).

Thanks-

--Mike-- Chain Reaction Bicycles
http://www.ChainReactionBicycles.com
 
Hi Mike!

Take a look at Format > Conditional Formatting

You have a choice of using pre-sets for the Cell value or your own
custom formula. Remember with custom formulas that they must evaluate
to TRUE or FALSE.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Thanks, I found it just about the same time you posted. OK, now for
something a little bit tougher.

So you apply the conditional formatting to those cells... is there a way to
change the formatting of a different cell based on the original one?
(Obviously there is, I just haven't figured it out yet! :>)

--Mike-- Chain Reaction Bicycles
http://www.ChainReactionBicycles.com
 
Hi Mike!

Select (say) B1
Format > Conditional Formatting
Formula Is:
=A1>7
Format Button
Select Format to taste
OK
OK

You'll find that Chip Pearson has a good exposition on conditional
formatting and a whole lot else:

http://www.cpearson.com/excel/cformatting.htm

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi Mike,
You want your formula to be used on the entire row
to get your color change for the entire row; therefore,
you need to place a $ sign in front of the Column letter
so that all cells on each row are checking a specific
column on their own row.

Cells eligible for coloring are based on selection,
The formula used is based on the active cell.
The objective of the formula is return True (i.e. not zero),
or False (i.e. zero).

Select the first cell in the column you want to check (i.e. D1)
Select all cells on the worksheet (Ctrl+A)
which keeps D1 as your active cell on which formula is based
Format, Conditional Formatting
C.F. Formula 1 is: =$D1>7

For more information on Conditional Formatting see
http://www.mvps.org/dmcritchie/excel/condfmt.htm

Thanks for posting with a descriptive subject title,
it helps everyone including those that search archives
for previous postings.
 
Thanks for posting with a descriptive subject title,
it helps everyone including those that search archives
for previous postings.
Click to expand...

I know what you mean. I reply to quite a few posts on rec.bicycles.misc &
rec.bicycles.tech, and there just isn't enough time in the day to scan every
post.

Sigh. I'm much more comfortable with bicycles & databases than I am with
Excel. Guess it's about time I learn something new...

PS: Thanks for the info, I'll try to figure it all out.

--Mike-- Chain Reaction Bicycles
http://www.ChainReactionBicycles.com
 
Back
Top