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

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.
 
G

Guest

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 4th Condition 3
Conditional Formatting Driving Me Crazy 1
Conditional Formatting 1
IF Statement - compare to coloured cell 7
IF OR AND in same conditional formula 2
Using Dates in Conditional Formatting 9
Conditional Formatting 3
If function using cell format as the condition 2

Top