Conditional Formatting/If statement

[aicylaaa]

Hello everyone,

I'm not sure if this is how I would go about this (using an if statement or what) but I can't figure out a way to make it so a cell will auto-fill with a certain color based on information in a different cell.

I have information in column B - either "New Group" or "Renewal"
I want column F to auto-fill to black if column B is a "Renewal"

I'm new to excel and I've been googling and I can't seem to figure out if this is even possible?

Thanks so much!

 

[Joe4]

Welcome to the Board!

Yes, this is possible, and actually quite easy. Here is how:

1. Select all the cells in column F that you want to apply this to. Let's say it is F2:F100 for this example.
2. Go to Conditional Formatting, and select the Formula option.
3. Enter the formula as it applies to the FIRST cell in the range you selected up in Step 1 (Excel will automatically adjust it for the others).
So that would look something like this:
=$B2="Renewal"
4. Choose your desired formatting option (fill color)
5. Click OK

That is it!

 

[philwojo]

Highlight all of the cells you want to fill with black in column-F, then click on Conditional Formatting (CF) and put this in as a new rule using a formula.

=b1="Renewal"

Then set your formatting.

B1 assumes the value you want to look at is in B1, update as necessary for your data.

 

[aicylaaa]

Welcome to the Board!

Yes, this is possible, and actually quite easy. Here is how:

1. Select all the cells in column F that you want to apply this to. Let's say it is F2:F100 for this example.
2. Go to Conditional Formatting, and select the Formula option.
3. Enter the formula as it applies to the FIRST cell in the range you selected up in Step 1 (Excel will automatically adjust it for the others).
So that would look something like this:
=$B2="Renewal"
4. Choose your desired formatting option (fill color)
5. Click OK

That is it!

This worked! Thanks so much!

 

[Joe4]

You are welcome.