Conditionally formatting the Total line on a Table

Hello,

I am having an issue when I apply a conditional format to a table in excel. Basically I want the conditional format to act similarly for the Total line, as it does for the rest of the table but it does not. I have a simple table. I want each value in the TAT field to turn red if it is greater than the value in the Goal field. My conditional formatting works for everything except the Total line! Can you help me figure this out!

See the file in the reply below:


Thanks in advance.

the number in Total row in the Goal Column was a text number not an actual number if you convert to a real number, it seem to work....

I changed your Formula a bit in the CF

I'm glad it worked for you.....have a great day....

Thanks for setting the thread to Solved...If you feel I deserve an increase in my reputation, feel free to click on the star in the lower left of the thread. Remember, someday when you help somebody they may add to your rep points, and it could be me...just a thought...