Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional Formatting - Formula based
Just a question - I'm not sure exactly how to google what I want to
know. I am interested in using conditional formatting, formula based, where using a variable length sheet, compare column F values to adjacent column G values - if F is greater than G, color H red, if F is less than G color H blue. I wasn't sure how to make it work for the whole column. Ideas? Ben/ND |
#2
|
|||
|
|||
In the first cell of your data in column H (Say its H1 for sake of example)
use these formulas, and drag down to the end of your data: In the first condition: =F1G1 and make this formatting Red Then, make a second condition (formula based again) and enter this formula: =G1F1 and make this formatting Blue. -- Regards, Dave "Nick Danger" wrote: Just a question - I'm not sure exactly how to google what I want to know. I am interested in using conditional formatting, formula based, where using a variable length sheet, compare column F values to adjacent column G values - if F is greater than G, color H red, if F is less than G color H blue. I wasn't sure how to make it work for the whole column. Ideas? Ben/ND |
#3
|
|||
|
|||
One way
Highlight column H FormatConditional Formating Condition 1Formula is =if(F1G1,true,false) format color to red Condition 2 formula is =if(G1F1,true,false) format color to blue Use ctrl + enter HTH "Nick Danger" wrote: Just a question - I'm not sure exactly how to google what I want to know. I am interested in using conditional formatting, formula based, where using a variable length sheet, compare column F values to adjacent column G values - if F is greater than G, color H red, if F is less than G color H blue. I wasn't sure how to make it work for the whole column. Ideas? Ben/ND |
#4
|
|||
|
|||
Ray -
You don't need to use the IF() statement. The function =F1G1 (or =G1F1 for the second) will output the same thing. -- Regards, Dave "Ray A" wrote: One way Highlight column H FormatConditional Formating Condition 1Formula is =if(F1G1,true,false) format color to red Condition 2 formula is =if(G1F1,true,false) format color to blue Use ctrl + enter HTH "Nick Danger" wrote: Just a question - I'm not sure exactly how to google what I want to know. I am interested in using conditional formatting, formula based, where using a variable length sheet, compare column F values to adjacent column G values - if F is greater than G, color H red, if F is less than G color H blue. I wasn't sure how to make it work for the whole column. Ideas? Ben/ND |
#5
|
|||
|
|||
Worked like a charm. Don't know why I didn't think it'd be so
simple!!! Thanks very much! Ben / ND |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formulae, conditional formatting & macro security | Excel Discussion (Misc queries) | |||
Conditional formatting with dates formula problem. | Excel Discussion (Misc queries) | |||
Conditional Formatting based on month name | Excel Discussion (Misc queries) | |||
Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) |