conditional indirect with data range
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"
|