# Formula in Conditional Formatting

#### hcb42

##### New Member
I am trying to do something which I would think would be simple, but cannot get it to work!

I have two columns of data in Columns B and C
 Lodge1 20 18 Lodge 2 15 11 Lodge 3 33 30

<tbody>
</tbody>

I want to be able to shade Column C if it is lower than the corresponding value in column B
I have tried IF(C1<B1) but it doesnt seem to work, am I missing something Obvious?<b1) and="" then="" shaded="" etc,="" but="" it="" doesnt="" seem="" to="" work.="" am="" i="" missing="" something="" obvious?<b1)="" as="" formula="" shaded,="" doesn't="" obvious?<="" html=""></b1)>

Last edited:

### Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

#### hcb42

##### New Member
I have tried IF(c1 is less than symbol b1) but cannot get it to work, am I missing something obvious<b1) and="" then="" shaded="" accordingly,="" but="" it="" doesnt="" seem="" to="" work?="" am="" i="" missing="" something="" obvious?<="" html=""></b1)>

Last edited:

#### Trevor G

##### Well-known Member
Try this. Select the cells in Column C and then use Home Tab and Conditional formatting, select Highlight cells less than and then click the first cell in Column B hit F4 3 times and then select your format. that should work.

Excel Workbook
ABC
1Lodge11218
2Lodge 21511
3Lodge 33330
Sheet3
Cells with Conditional Formatting
CellConditionCell FormatStop If True
C11. / Cell Value less than =B1Abc
C21. / Cell Value less than =B1Abc
C31. / Cell Value less than =B1Abc

#### hcb42

##### New Member
Try this. Select the cells in Column C and then use Home Tab and Conditional formatting, select Highlight cells less than and then click the first cell in Column B hit F4 3 times and then select your format. that should work.

it does - thank you

#### Trevor G

##### Well-known Member
Happy to help and thanks for letting me know you have a solution....

#### Latha

##### Board Regular
hi,

you could do the same with formula as well...
First place the cursor/select the cell C2 and go to Conditional formatting -->highlight cells --> more rules
Select "Use a formula to determine which cells to format"
Then in the formula line type =C2<B2 and format the color as red and say ok
then copy the paste the format of C2 to other cells in Column C

Replies
1
Views
270
Replies
0
Views
415
Replies
0
Views
287
Replies
0
Views
794
Replies
3
Views
2K

1,195,945
Messages
6,012,445
Members
441,701
Latest member
vnkendijs

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back