G George Bundy Mar 25, 2004 #1 How do I do base my conditional formatting in the current cell on the value of a DIFFERENT cell??
B Bob Phillips Mar 25, 2004 #2 Change the CF condition to Formula Is and seta formula. So for instance, if you are in A1, you could have a formula of =B1>17 -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
Change the CF condition to Formula Is and seta formula. So for instance, if you are in A1, you could have a formula of =B1>17 -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
J Jason Morin Mar 25, 2004 #3 You need to change the drop-down box to "Formula Is" rather than "Cell Value Is". Then type in your statement such as: =A2<1 which reads "change the formatting of the active cell when A2 is less than 1." HTH Jason Atlanta, GA
You need to change the drop-down box to "Formula Is" rather than "Cell Value Is". Then type in your statement such as: =A2<1 which reads "change the formatting of the active cell when A2 is less than 1." HTH Jason Atlanta, GA
