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

" wrote:

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

Condtion 1 Formula is =$k12 format is Bold and Red
Condition 2 Formula is =$k11 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
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"