ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Conditional formatting comparing two columns (https://www.excelbanter.com/excel-worksheet-functions/247644-conditional-formatting-comparing-two-columns.html)

Shelina

Conditional formatting comparing two columns
 
Help! I need to create conditional formatting that highlights a cell, if the
value in column F is greater than the value in column B. How do I make that
work? Thanks!
--
Shelina

Jacob Skaria

Conditional formatting comparing two columns
 
1. Select the cell/Range (say F1:F10). Please note that the cell reference F1
mentioned in the formula is the active cell in the selection. Active cell
will have a white background even after selection..
2. From menu FormatConditional Formatting
3. For Condition1Select 'Formula Is' and enter the below formula
=F1B1

'To handle blank entries you can try the below formula
=AND(COUNT(F1,B1)=2,F1B1)

4. Click Format ButtonPattern and select your color (say Red)
5. Hit OK

PS: If you are using Excel 2007 Goto Home tabStylesConditional
FormattingManage rulesNew ruleUse a formula to determine which cells to
format

If this post helps click Yes
---------------
Jacob Skaria


"Shelina" wrote:

Help! I need to create conditional formatting that highlights a cell, if the
value in column F is greater than the value in column B. How do I make that
work? Thanks!
--
Shelina


Peo Sjoblom[_3_]

Conditional formatting comparing two columns
 
Select the range in column F, assume the first select cell is F2, then apply
conditional formatting, use formula is, then =F2B2, click the format
button, select patterns and choose high light colour then click OK Twice.
That would be for 2003 and earlier

For 2007 click the icon for cf, then select new rule, select use a formula
to determine which cells to format, put =F2B2 in the rule description, then
format button, select fill, then colour. As usual it is more steps involved
in the idiotic 2007



--


Regards,


Peo Sjoblom


"Shelina" wrote in message
...
Help! I need to create conditional formatting that highlights a cell, if
the
value in column F is greater than the value in column B. How do I make
that
work? Thanks!
--
Shelina




Shelina

Conditional formatting comparing two columns
 
Thanks for your help.

I am using 2007. I did as you suggested and random cells were highlighted,
non of them were examples of =F1B1. I tested =B1F1 and the resulting
highlighted cells were all the cells which were not highlighted in =F1B1. Do
you have any idea what might be happening there?
--
Shelina


"Jacob Skaria" wrote:

1. Select the cell/Range (say F1:F10). Please note that the cell reference F1
mentioned in the formula is the active cell in the selection. Active cell
will have a white background even after selection..
2. From menu FormatConditional Formatting
3. For Condition1Select 'Formula Is' and enter the below formula
=F1B1

'To handle blank entries you can try the below formula
=AND(COUNT(F1,B1)=2,F1B1)

4. Click Format ButtonPattern and select your color (say Red)
5. Hit OK

PS: If you are using Excel 2007 Goto Home tabStylesConditional
FormattingManage rulesNew ruleUse a formula to determine which cells to
format

If this post helps click Yes
---------------
Jacob Skaria


"Shelina" wrote:

Help! I need to create conditional formatting that highlights a cell, if the
value in column F is greater than the value in column B. How do I make that
work? Thanks!
--
Shelina


Jacob Skaria

Conditional formatting comparing two columns
 
--Make sure your selection is Range F1:F10. Please note that the cell
reference F1
mentioned in the formula is the active cell in the selection. Active cell
will have a white background even after selection..

--Copy paste the below formula
=AND(COUNT(F1,B1)=2,F1B1)

--Enter 1 in cell B1 and 2 in cell F1 (f1 should be highlighted)
--Enter 2 in cell B2 and 3 in cell F2 (f2 should be highlighted)
--Enter 2 in cell B3 and 1 in cell F3 (f3 will not be highlighted)

If this post helps click Yes
---------------
Jacob Skaria


"Shelina" wrote:

Thanks for your help.

I am using 2007. I did as you suggested and random cells were highlighted,
non of them were examples of =F1B1. I tested =B1F1 and the resulting
highlighted cells were all the cells which were not highlighted in =F1B1. Do
you have any idea what might be happening there?
--
Shelina


"Jacob Skaria" wrote:

1. Select the cell/Range (say F1:F10). Please note that the cell reference F1
mentioned in the formula is the active cell in the selection. Active cell
will have a white background even after selection..
2. From menu FormatConditional Formatting
3. For Condition1Select 'Formula Is' and enter the below formula
=F1B1

'To handle blank entries you can try the below formula
=AND(COUNT(F1,B1)=2,F1B1)

4. Click Format ButtonPattern and select your color (say Red)
5. Hit OK

PS: If you are using Excel 2007 Goto Home tabStylesConditional
FormattingManage rulesNew ruleUse a formula to determine which cells to
format

If this post helps click Yes
---------------
Jacob Skaria


"Shelina" wrote:

Help! I need to create conditional formatting that highlights a cell, if the
value in column F is greater than the value in column B. How do I make that
work? Thanks!
--
Shelina


Shelina

Conditional formatting comparing two columns
 
I have data validation going on in column B, which doesn't allow me to use
small numbers, so I added two columns to the table and did as you suggested.
The result was that all three cells were highlighted. Then, I added 4,5,6 to
three other cells in the first column (in this case, M) and 6,5,4 in the
adjoining cells in the second column (N). I used =N1M1. The result was that
the, in column N, containing 5 was highlighted.

I think there is something wrong with the table. I am working on a class
assignment and the table was created by the teacher, so I don't know what
might be going on there.
--
Shelina


"Jacob Skaria" wrote:

--Make sure your selection is Range F1:F10. Please note that the cell
reference F1
mentioned in the formula is the active cell in the selection. Active cell
will have a white background even after selection..

--Copy paste the below formula
=AND(COUNT(F1,B1)=2,F1B1)

--Enter 1 in cell B1 and 2 in cell F1 (f1 should be highlighted)
--Enter 2 in cell B2 and 3 in cell F2 (f2 should be highlighted)
--Enter 2 in cell B3 and 1 in cell F3 (f3 will not be highlighted)

If this post helps click Yes
---------------
Jacob Skaria


"Shelina" wrote:

Thanks for your help.

I am using 2007. I did as you suggested and random cells were highlighted,
non of them were examples of =F1B1. I tested =B1F1 and the resulting
highlighted cells were all the cells which were not highlighted in =F1B1. Do
you have any idea what might be happening there?
--
Shelina


"Jacob Skaria" wrote:

1. Select the cell/Range (say F1:F10). Please note that the cell reference F1
mentioned in the formula is the active cell in the selection. Active cell
will have a white background even after selection..
2. From menu FormatConditional Formatting
3. For Condition1Select 'Formula Is' and enter the below formula
=F1B1

'To handle blank entries you can try the below formula
=AND(COUNT(F1,B1)=2,F1B1)

4. Click Format ButtonPattern and select your color (say Red)
5. Hit OK

PS: If you are using Excel 2007 Goto Home tabStylesConditional
FormattingManage rulesNew ruleUse a formula to determine which cells to
format

If this post helps click Yes
---------------
Jacob Skaria


"Shelina" wrote:

Help! I need to create conditional formatting that highlights a cell, if the
value in column F is greater than the value in column B. How do I make that
work? Thanks!
--
Shelina


Jacob Skaria

Conditional formatting comparing two columns
 
Try out in a new workbook

If this post helps click Yes
---------------
Jacob Skaria


"Shelina" wrote:

I have data validation going on in column B, which doesn't allow me to use
small numbers, so I added two columns to the table and did as you suggested.
The result was that all three cells were highlighted. Then, I added 4,5,6 to
three other cells in the first column (in this case, M) and 6,5,4 in the
adjoining cells in the second column (N). I used =N1M1. The result was that
the, in column N, containing 5 was highlighted.

I think there is something wrong with the table. I am working on a class
assignment and the table was created by the teacher, so I don't know what
might be going on there.
--
Shelina


"Jacob Skaria" wrote:

--Make sure your selection is Range F1:F10. Please note that the cell
reference F1
mentioned in the formula is the active cell in the selection. Active cell
will have a white background even after selection..

--Copy paste the below formula
=AND(COUNT(F1,B1)=2,F1B1)

--Enter 1 in cell B1 and 2 in cell F1 (f1 should be highlighted)
--Enter 2 in cell B2 and 3 in cell F2 (f2 should be highlighted)
--Enter 2 in cell B3 and 1 in cell F3 (f3 will not be highlighted)

If this post helps click Yes
---------------
Jacob Skaria


"Shelina" wrote:

Thanks for your help.

I am using 2007. I did as you suggested and random cells were highlighted,
non of them were examples of =F1B1. I tested =B1F1 and the resulting
highlighted cells were all the cells which were not highlighted in =F1B1. Do
you have any idea what might be happening there?
--
Shelina


"Jacob Skaria" wrote:

1. Select the cell/Range (say F1:F10). Please note that the cell reference F1
mentioned in the formula is the active cell in the selection. Active cell
will have a white background even after selection..
2. From menu FormatConditional Formatting
3. For Condition1Select 'Formula Is' and enter the below formula
=F1B1

'To handle blank entries you can try the below formula
=AND(COUNT(F1,B1)=2,F1B1)

4. Click Format ButtonPattern and select your color (say Red)
5. Hit OK

PS: If you are using Excel 2007 Goto Home tabStylesConditional
FormattingManage rulesNew ruleUse a formula to determine which cells to
format

If this post helps click Yes
---------------
Jacob Skaria


"Shelina" wrote:

Help! I need to create conditional formatting that highlights a cell, if the
value in column F is greater than the value in column B. How do I make that
work? Thanks!
--
Shelina



All times are GMT +1. The time now is 04:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com