conditional indirect with data range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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???
 
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
 
Back
Top