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
|