I am trying to set up a conditional formula to look at a value in row "K"
then highlight the entire row. The catch is that I want it to highlight in
red if the value is between "1 years, 0 months, 0 days" and "2 years, 0
months, 0 days" and I want it to be bold red if the value is greater than "2
years, 0 months, 0 days" My current formula is =INDIRECT("K"&ROW())>"1
years, 0 months, 0 days"

It seems like you just need two Conditions for your format:

Condtion 1 Formula is =$k1>2 format is Bold and Red
Condition 2 Formula is =$k1>1 format is Red

Apply this to all columns in the relevant rows. I don't think you
need the indirect.

Good luck.

Ken
Norfolk, Va




On Jun 22, 4:32 pm, research lost <research
l...@discussions.microsoft.com> wrote:
> I am trying to set up a conditional formula to look at a value in row "K"
> then highlight the entire row. The catch is that I want it to highlight in
> red if the value is between "1 years, 0 months, 0 days" and "2 years, 0
> months, 0 days" and I want it to be bold red if the value is greater than "2
> years, 0 months, 0 days" My current formula is =INDIRECT("K"&ROW())>"1
> years, 0 months, 0 days"

I understand the formula but am running into a problem. I have the data
already in place and need to apply the conditional to those rows already
present. With the indirect I have applied to the whole sheet I can get a row
to change to red if the value in its respective K cell is greater than 1.
But when I tried to do another INDIRECT much like you describe they all stay
red and do not bold

"(E-Mail Removed)" wrote:

> It seems like you just need two Conditions for your format:
>
> Condtion 1 Formula is =$k1>2 format is Bold and Red
> Condition 2 Formula is =$k1>1 format is Red
>
> Apply this to all columns in the relevant rows. I don't think you
> need the indirect.
>
> Good luck.
>
> Ken
> Norfolk, Va
>
>
>
>
> On Jun 22, 4:32 pm, research lost <research
> l...@discussions.microsoft.com> wrote:
> > I am trying to set up a conditional formula to look at a value in row "K"
> > then highlight the entire row. The catch is that I want it to highlight in
> > red if the value is between "1 years, 0 months, 0 days" and "2 years, 0
> > months, 0 days" and I want it to be bold red if the value is greater than "2
> > years, 0 months, 0 days" My current formula is =INDIRECT("K"&ROW())>"1
> > years, 0 months, 0 days"
>
>
>

got it. I had to switch my conditions so that greater than 2 was first and
greater than 1 was second. No one more problem....One of my dates is 14
years out and it is being recognized as 1 year...thus red and not bold. any
suggestions???

"(E-Mail Removed)" wrote:

> It seems like you just need two Conditions for your format:
>
> Condtion 1 Formula is =$k1>2 format is Bold and Red
> Condition 2 Formula is =$k1>1 format is Red
>
> Apply this to all columns in the relevant rows. I don't think you
> need the indirect.
>
> Good luck.
>
> Ken
> Norfolk, Va
>
>
>
>
> On Jun 22, 4:32 pm, research lost <research
> l...@discussions.microsoft.com> wrote:
> > I am trying to set up a conditional formula to look at a value in row "K"
> > then highlight the entire row. The catch is that I want it to highlight in
> > red if the value is between "1 years, 0 months, 0 days" and "2 years, 0
> > months, 0 days" and I want it to be bold red if the value is greater than "2
> > years, 0 months, 0 days" My current formula is =INDIRECT("K"&ROW())>"1
> > years, 0 months, 0 days"
>
>
>

You have to be careful about the order of conditional formats. I am
not sure why a date 14 year out would not be greater than 2. You can
narrow down the problem by checking whether the value in column k in
that row, e.g. 5, is evaluated as being greater than 2 with a formula
like inany cell

=k5>2

If that evalautes to False, then the problem is in the data. If it is
true, then the problem is probably somewhere in the condition logic.

Ken


On Jun 22, 5:07 pm, research lost
<researchl...@discussions.microsoft.com> wrote:
> got it. I had to switch my conditions so that greater than 2 was first and
> greater than 1 was second. No one more problem....One of my dates is 14
> years out and it is being recognized as 1 year...thus red and not bold. any
> suggestions???
>
>
>
> "krco...@aol.com" wrote:
> > It seems like you just need two Conditions for your format:
>
> > Condtion 1 Formula is =$k1>2 format is Bold and Red
> > Condition 2 Formula is =$k1>1 format is Red
>
> > Apply this to all columns in the relevant rows. I don't think you
> > need the indirect.
>
> > Good luck.
>
> > Ken
> > Norfolk, Va
>
> > On Jun 22, 4:32 pm, research lost <research
> > l...@discussions.microsoft.com> wrote:
> > > I am trying to set up a conditional formula to look at a value in row "K"
> > > then highlight the entire row. The catch is that I want it to highlight in
> > > red if the value is between "1 years, 0 months, 0 days" and "2 years, 0
> > > months, 0 days" and I want it to be bold red if the value is greater than "2
> > > years, 0 months, 0 days" My current formula is =INDIRECT("K"&ROW())>"1
> > > years, 0 months, 0 days"- Hide quoted text -
>
> - Show quoted text -