conditional formattion of adjacent cell

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
 
T

Tom Ogilvy

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

Conditional Formatting with VBA 4
Conditional format based on adjacent cell value 3
Conditional Formatting macro: simple, but doesn't work 6
Capturing conditional Interior Color of cell 2
Macro to find the value of adjacent cell from a range of values 2
Conditional Formatting... 2
IF - formatting problem 8
change current cell colour based on the value of adjacent cell on other worksheet 2

Top