Custom formatting

W

WillieWoman

I am new at this... I have a criteris of <5 years, >=5 years. I have tried
everything to have this apply to a column of numbers. Can anyone help me?
 
J

Joel

Here are step by step instructions.

1) Highlight cells you want conditional formating
2) go to Tools Menu and Select conditional formating
3) Select condition 1 Cell value is
4) The box to the right select less than
5) Next box type in 5
6) Press format button - select pattern. Pick color
7) Press OK
8) Press Add button
9) Select condition 2 Cell value is
10) The box to the right select greater thanor equal to
11) Next box type in 5
12) Press format button - select pattern. Pick color
13) Press OK
 
W

WillieWoman

Thank you Joel. I failed to mention I have to include "years" as part of the
answer. No colors involved. Instruction writes:
"Create a custom format for the values in the Years Employed column so that
is displays the text "<5years" for values that are less than five and ">=5
years" for values that are less than or equal to five or greater" Excel 2003,
Second Edition, Parsons, Oja, Ageloff, Carey
 
J

Joel

You left out the hard part. The code below will strip the string "years" and
convert the text number to an integer. Here are step by step instructions.

1) Highlight cells you want conditional formating
2) go to Tools Menu and Select conditional formating
3) Select condition 1 formula is
4) The box to the right enter:
=IF(VALUE(SUBSTITUTE(F5,"years",""))<5,TRUE,FALSE)
5) Press format button - select pattern. Pick color
6) Press OK
7) Press Add button
8) Select condition 2 formula is
9) The box to the right enter:
=IF(VALUE(SUBSTITUTE(F5,"years",""))>=5,TRUE,FALSE)
10) Press format button - select pattern. Pick color
11) Press OK
 
Top