Conditional Formatting on DIFFERENT cell

  • Thread starter Thread starter George Bundy
  • Start date Start date
G

George Bundy

How do I do base my conditional formatting in the current
cell on the value of a DIFFERENT cell??
 
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)
 
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 must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting 1
Excel Highlighting duplicates 0
Conditional format a column based on value in a different column 3
Conditional Format Won't Update Cell 8
Excel Conditional Formatting 1
Excel Macro to automatically go to the right of the last colored cell 0
Conditional Formatting 3
Conditional Format - using 3 different cells conditions together 4

Back
Top