Formatting 2 cells based on another cell

[snaxxy]

Hi there,

I have attached a sample spreadsheet to show you what I mean by this.

Formatting Test.xlsx

If cell B is less than or equal to cell C, for both of them to be filled green.

If Cell B is more than cell C then not to format anything.

Also, is there a quick way to copy this formula as I have other sheets which use the same information (but don't use cells B & C)?

Many thanks,
Gary

[npamcpp]

Select cells B2 and C2 and add a conditional format with a rule that uses a formula. This is the formula

=$B2<=$C2

Set the format to a green fill.

You can copy the two cells and use Paste Special > Formats to apply the same formatting to other rows.

If you want the formatting to work in other columns than B and C, you will need to set up individual rules for each column. The cell references are relative to the current cell, so you need to construct your formulas accordingly.

[snaxxy]

Excellent, thanks very much. I didn't realise you could put one dollar sign... I thought they could only be $B$2 for example!

Exactly what I wanted.

[npamcpp]

mind you that $B1 copied across will always refer to column B.

You may want to learn a bit more about absolute and relative cell references.

[Cutter]

@ snaxxy

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.