conditional formattion of adjacent cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can you do a conditional formatting of the adjacent call based on values in
current cell..e.g. if value of A1=0 then B1 cell color should be red
 
Change your thinking to where current cell is to be formatted and adjacent
cell has the value - thus

Select B1, then do format, conditional formattiing
change Cell Value is to Formula is and use a formula like

=A1=0

and select your formatting option
 

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

Macro to find the value of adjacent cell from a range of values 2
Display entire number in cell 3
Conditional format based on adjacent cell value 3
Conditional Formatting with VBA 4
Conditional Formatting... 2
Using code to insert different formulas 3
Conditional Formatting macro: simple, but doesn't work 6
Capturing conditional Interior Color of cell 2

Back
Top