May 22 2007, 07:13 AM
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?
May 22 2007, 07:15 AM
Have you tried an If statement?
May 22 2007, 07:33 AM
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?
May 22 2007, 07:36 AM
Change the format condition to "Formula Is", then use the following:
May 22 2007, 07:43 AM
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!
May 22 2007, 07:50 AM
glad I could help
May 22 2007, 11:31 AM
no need for an IF, a plain
will do (as it returns kind of boolean)
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here