IF statement and color formatting for cell B1 for condition in A1

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

Guest

I'm trying to generate a color-background format result in one cell (cell B1
for instance) when a condition in another cell (A1) is met. I've tried
conditional formatting but it seems to apply only to conditions being met the
same cell that is affected.
 
Hi Rossta,

Make sure the 'formula is' option is selected under conditional formatting
and then something like =$A$1>5 in cell B1 will change B1 to your selected
format when the value in A1 is greater than 5.
 

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
Conditional Formatting Driving Me Crazy 1
Conditional Format - using 3 different cells conditions together 4
If function with format 1
Excel VBA 1
Conditional Formatting in 2007 3
Cell Formatting of a Conditional Statement 3
Changing Color of the Cell under Certain Conditions 8

Back
Top