I get Conditional Formating and how to do it. My problem is that I want to change the format of a cell that doesn't have the data in it. Let me see if I can explain.

In cell B6 is the name of a country. I want to change the formatting in THAT cell based on whether or not the number in D6 is below 70%. I haven't been able to figure out how to do that. I can change formatting in D6 based on the number in itself - but I can't change the formatting in B6 (which has a name in it - but not the data that the rules for the conditional formatting). Am I making sense?

Any ideas?

Thanks!

Have you tried an If statement?

I was thinking that would be what I needed to do, but I'm a relative newby to the more advanced features of Excel and I wasn't sure how to do that with formating. Any suggestions?

Change the format condition to "Formula Is", then use the following:

=IF(D6<0.7,TRUE,FALSE)

HTH
Matt

THAT WAS GREAT! Thank you very much. I knew it had to be easy I just was stuck in getting started. Thank you so much!

glad I could help

Hello,

no need for an IF, a plain

=D6<0.7

will do (as it returns kind of boolean)

Martin